Forum Discussion

prasadhebbar315's avatar
prasadhebbar315
Advocate I
3 years ago
Solved

Compare two dates to create flag

Hello all, I am looking at a solution to identify if there exists ML_date before Escalation_Date by each Serial number. In the below table, for Serial_Number:100 , Escalation_Date is 3/2/2023 but t...
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    try a calculated column with this DAX:

     

    Column = var _mindate = CALCULATE(min('Table'[ML_Date]),ALLEXCEPT('Table','Table'[Serial_Number]))

    return

    if ('Table'[Escalation_Date] < _mindate, "No", "Yes")
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi, 

    you can add a calculated column

    Column =
    VAR currser = 'Table'[Serial_Number]

    VAR minMLdate = CALCULATE( MIN('Table'[ML_Date]), FILTER('Table', 'Table'[Serial_Number]=currser ))
    RETURN
    IF( 'Table'[Escalation_Date] >= minMLdate, "yes", "no" )
     

    If this post is useful to help you to solve your issue consider giving the post a thumbs up 

     and accepting it as a solution !

serpiva64's avatar
serpiva64
Solution Sage
3 years ago

Hi, 

you can add a calculated column

Column =
VAR currser = 'Table'[Serial_Number]

VAR minMLdate = CALCULATE( MIN('Table'[ML_Date]), FILTER('Table', 'Table'[Serial_Number]=currser ))
RETURN
IF( 'Table'[Escalation_Date] >= minMLdate, "yes", "no" )
 

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !