Forum Discussion

M_SBS_6's avatar
M_SBS_6
Icon for Helper V rankHelper V
1 year ago
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...
Need Help
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    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

  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    M_SBS_6 

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi M_SBS_6 ,

Thanks for all the replies!
Please check to see if these replies can help you. If solved please accept the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Best Regards,
Dino Tao