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.
Anonymous ,
I do not have the ref data as a column and am trying to create a measure for it. Any thoughts on how to replicate the ref data with a measure?
Is the ref data in another table?
Could you connect the tables by the Test Index Number?
I need to pull the ref data from the data column in the by looking at the Ref ID.