Forum Discussion

KiranPatil's avatar
KiranPatil
Frequent Visitor
7 years ago
Solved

DAX

Hi Guys :)

 

I have the below data set . I need a column "Flag" to be created  at backend using DAX . Help me to achieve it

 

IDStageStatusStatus Time Flag
1ScreeningPending01-01-20180
1ScreeningSelected02-01-20181
1CETSelected03-01-20181
1PLAPending04-01-20180
1PLARejected05-01-20181
1OfferPending06-01-20180
1OfferAccepted07-01-20181
1JoinedJoining08-01-20181
2ScreeningSelected09-01-20181
2CETSelected10-01-20181
2PLASelected11-01-20181
2OfferAccepted12-01-20181
2JoinedJoining13-01-20181



For each ID and each Stage wise , i need to fetch MAX ( Status Time ) as Flag 1 .

Advance Thanks :)

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi KiranPatil,

     

    flag =
IF (
    table4[Status Time ]
        = CALCULATE (
            MAX ( table4[Status Time ] ),
            ALLEXCEPT ( table4, table4[ID], table4[Stage] )
        ),
    1,
    0
)

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi KiranPatil,

     

    flag =
IF (
    table4[Status Time ]
        = CALCULATE (
            MAX ( table4[Status Time ] ),
            ALLEXCEPT ( table4, table4[ID], table4[Stage] )
        ),
    1,
    0
)

     

    Best regards,

    Yuliana Gu