DAX Help - Lookup to return value

[Anonymous]

Hello Community,

I have a set of data in multipule tables I am looking to cross reference to return an alternative value.

The below images are of the tables and the data

I have made the below table to showing Run ID, Ref ID and Data.

What I am having trouble creating is a measure that returns a difference of the Run ID vs. the Ref ID

Example of what is expected;

In row 4 of the above table

Run ID 4 = Data 11

Ref ID 2 = (Run ID 2) = Data 8

The subtracted value of Run ID 4 from Ref ID 2 would be 3 (11-8).

If correct, the rows of the expected measure in the above table would be

Null

3 (8-5)

0 (7-7)

3 (11-8)

4 (9-5)

I have tried a few lookup options with this but not been able to achive the desired result.

Any suggestions appreciated!!

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

I did it two ways, one with measures and joins and the other as a set of calculated columns added to the ConFig table.

MeasuresCalculated Columns

I uploaded my .pbix file here for you to take a look at so you can decide which way you like best.

https://www.dropbox.com/s/n3ok5ikaesjeluo/RunAndRefData.pbix?dl=0

[Anonymous]

@jdbuchanan71 ,

Thanks this has me pointed in the right direction!