Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Help - Measure to find difference

Community, I am having difficulty writing DAX to find the differnce between various test results. Seamed simple. Any help on the topic is apperciated.   Below is example data and what I would lik...
Need Help
  • Geradav's avatar
    Geradav
    7 years ago

    After looking at Anonymous , using the LOOKUPVALUE() function makes more sense

    Dif2 =
VAR vCurrentTestIDtoRef = 'Table1 (2)'[Test ID to Ref]
VAR vCurrentTestMap = 'Table1 (2)'[Test Map]
VAR vRefNum =
    LOOKUPVALUE (
        'Table1 (2)'[Data_Col],
        'Table1 (2)'[Test ID], vCurrentTestIDtoRef,
        'Table1 (2)'[Test Map], vCurrentTestMap
    )
RETURN
    'Table1 (2)'[Data_Col] - vRefNum
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous ,

Your response is correct, I put the incorrect data in the example for Data ID 3.

Can offer some insight on how to create a new table with the data related such that I can complete finding the difference mentioned in the original post?

 

Thanks.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If you have two tables with relationship create a new collumn and use lookup value() to easily find values. please refer to the following link for details:

https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

If need more help let me knkow.

 

If this reply solves your problem please accept it as solution to help others find the right answer.