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   ID Stage Status Status Time  Flag 1 Screening Pending 01...
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

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