Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
KiranPatil
Frequent Visitor

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 🙂

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @KiranPatil,

 

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

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @KiranPatil,

 

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

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-yulgu-msft a lot  . Worked

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.