Forum Discussion
Comparing data (dates) from the same table with same ID, and displaying the max date
Hi, I was wondering if it's possible to compare dates within the same table with same ID, but the catch is that there is an additional column that display the status. For instance, here's a table...
Hi bcwan,
You can create a measure using DAX formula like below:
Date(highest date) = CALCULATE(MAX(Table1[Date]), ALLEXCEPT(Table1, Table1[ID]))
Regards,
Jimmy Tao
Hi bcwan,
You can create a measure using DAX formula like below:
Date(highest date) = CALCULATE(MAX(Table1[Date]), ALLEXCEPT(Table1, Table1[ID]))
Regards,
Jimmy Tao