Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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-01-2018 | 0 |
1 | Screening | Selected | 02-01-2018 | 1 |
1 | CET | Selected | 03-01-2018 | 1 |
1 | PLA | Pending | 04-01-2018 | 0 |
1 | PLA | Rejected | 05-01-2018 | 1 |
1 | Offer | Pending | 06-01-2018 | 0 |
1 | Offer | Accepted | 07-01-2018 | 1 |
1 | Joined | Joining | 08-01-2018 | 1 |
2 | Screening | Selected | 09-01-2018 | 1 |
2 | CET | Selected | 10-01-2018 | 1 |
2 | PLA | Selected | 11-01-2018 | 1 |
2 | Offer | Accepted | 12-01-2018 | 1 |
2 | Joined | Joining | 13-01-2018 | 1 |
For each ID and each Stage wise , i need to fetch MAX ( Status Time ) as Flag 1 .
Advance Thanks 🙂
Solved! Go to Solution.
Hi @KiranPatil,
flag = IF ( table4[Status Time ] = CALCULATE ( MAX ( table4[Status Time ] ), ALLEXCEPT ( table4, table4[ID], table4[Stage] ) ), 1, 0 )
Best regards,
Yuliana Gu
Hi @KiranPatil,
flag = IF ( table4[Status Time ] = CALCULATE ( MAX ( table4[Status Time ] ), ALLEXCEPT ( table4, table4[ID], table4[Stage] ) ), 1, 0 )
Best regards,
Yuliana Gu
User | Count |
---|---|
105 | |
98 | |
97 | |
68 | |
34 |
User | Count |
---|---|
146 | |
141 | |
116 | |
98 | |
52 |