Forum Discussion
Problem with comparing two CALCULATEDTABLES & with MAX WEEK
Dear Community, Firstly, I would like to show some sample data table and it's format. These are testing data on which I would like to explain my problem: Task description: One slicer has to b...
Hello amitchandak
Your proposed solution by using RANK solved my MAX_WEEK issue - thanks! But still I have no clue how to compare two calculated tables.
Best regards!
HI serax,
Perhaps you can try to use ADDCOLUMNS and LOOKUPVALUE functions to add new table columns to the current table based on id.
ADDCOLUMNS function (DAX) - DAX | Microsoft Learn
LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
Regard,
Xiaoxin Sehng