relatedtable

  1. R

    Power Pivot CALCULATE vs. RELATEDTABLE

    I'm a beginner with Power Pivot/DAX, and got thinking about that: Given two tables: items and groups, related by columns [groupid]. I create calculated columns in the groups table. There is more than one way to do it: groups[n items 1]=COUNTROWS(RELATEDTABLE(items)) groups[max fact...
  2. S

    If statement Dax function as a measure

    Hello Everyone, I am looking for a dax measure function based on the following logic i have three tables, Table No.1 <tbody> <tbody> Category </tbody> <tbody> Online Price </tbody> <tbody> Offline Price </tbody> <tbody> Laptop </tbody> 38000 42000 <tbody> TV...
  3. M

    Using VALUES with RELATEDTABLE

    I have (simplified) 2 lookup tables (Requisitions and Departments) and a fact table (PurchaseOrders). I need to find who the requisitioners are for each department that created a PO for a particular vendor, with the Requesters field in the Requisitions table. Requisitions is linked to orders...
  4. E

    DAX DISTINCTCOUNT on a related table

    Hi, I have a TMOV table containing DATE and PRODUCT columns, among other columns, that is related with a TDATE table containing DATE and YEAR_MONTH columns. I would like to populate an additional column in the TMOV table with DISTINCTCOUNT of YEAR_MONTHS by PRODUCT, i.e. number of months that...
  5. C

    Difference between Related and RelatedTable

    Can't really tell the difference between the two. Can anyone explain in layman terms, please? Thanks!

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top