Forum Discussion

someuser999's avatar
someuser999
New Member
8 years ago
Solved

Dax question about comparing non-adjacent row values in same column

Comparing row values. In Dax, for each subject and test item, how to determine the difference (numeric) between the type 3 result and the type 1 result? Subject Tester TestType TestItem1 TestItem2 ...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,
    wondering if you considered to use
    LOOKUPVALUE 

    https://msdn.microsoft.com/en-us/query-bi/dax/lookupvalue-function-dax

    in combination with unpivoting the columns TestItem1 ... TestItem3

     

     

    If this is not what you are looking for, please consider to create a pbix file that contains sample data, upload the file to onedrive or dropbox and share the link.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
8 years ago

Hey,
wondering if you considered to use
LOOKUPVALUE 

https://msdn.microsoft.com/en-us/query-bi/dax/lookupvalue-function-dax

in combination with unpivoting the columns TestItem1 ... TestItem3

 

 

If this is not what you are looking for, please consider to create a pbix file that contains sample data, upload the file to onedrive or dropbox and share the link.

 

Regards,

Tom

someuser999's avatar
someuser999
New Member
8 years ago
Looks like that could work. Could it be done without hard coding all the search column values?
  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    8 years ago

    Hey,

     

    basically you can use variables that reduces hardcoding dramtically, also consider to pivot the columns Testresult1 - Testresult3 into one column

     

    Everything gets much more simple if you provid a pbix with sample data, upload the file to onedrive or dropbox and share the link.

     

    Regards

    Tom