Forum Discussion
Solved
Latest Date by Column Value
Hi, I have several columns in my table and I'd like to flag a 1 or 0 in another column based on the latest date by product. Any idea how to do this please? ID. Date. Product. Fl...
M_SBS_6 Create a calculated column using the below DAX
Flag = var maxdate = CALCULATE(MAX(MyTable[Date]) , ALLEXCEPT(MyTable,MyTable[Product])) RETURN IF( MyTable[Date] = maxdate , 1 , 0 )Output:
Did I answer your question ? If yes, please mark my post as a solution.
Thanks,
Jai
New column:
Flag =
VAR LatestDate =
CALCULATE(
MAX('Table'[Date]),
FILTER(
'Table',
'Table'[Product] = EARLIER('Table'[Product])
)
)
RETURN
IF('Table'[Date] = LatestDate, 1, 0)💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
M_SBS_6 Create a calculated column using the below DAX
Flag =
var maxdate = CALCULATE(MAX(MyTable[Date]) , ALLEXCEPT(MyTable,MyTable[Product]))
RETURN
IF( MyTable[Date] = maxdate , 1 , 0 )
Output:
Did I answer your question ? If yes, please mark my post as a solution.
Thanks,
Jai