Forum Discussion
DAX Help - CrossFilter and LookUp
Community, I am trying to return a difference using multiple tables. I need assistance with DAX for a measure that will return the correct result. I have two tables... Table1 where; Test Index...
As long as the data in the green column is connected via a relationship to Table1/Table2, then the following code should work in a calculated column:
Difference = Table2[Data] - RELATED ( RefData[Ref Data] )
This uses the RELATED function to get the relevant value from the green column.