Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
could you help me come up with a calculated column that shows "Failed VOE", when the next phase after Verification of Effectiveness/Verification of Effectiveness approval is Initial response? the Phase_tick_id are giving the correct order of the phases.
Thanks a lot!! forever grateful to whom can help me
Kind regards,
Alessandra
Solved! Go to Solution.
modify to this :
cc =
if(
(tbl[PHASE NAME] = "Verification of Effectiveness" || tbl[PHASE NAME] = "Verification of Effectiveness approval") &&
selectcolumns(
offset ( 1 ,
summarize ( tbl , tbl[PHASE NAME] , tbl[PHASE TICK_ID-1]) ,
orderby( tbl[PHASE TICK_ID-1] , asc ) ,
PARTITIONBY(tbl[INTERNAL_AUDIT_RESPONSE_NUMBER])
),
"@PHASE NAME" , tbl[PHASE NAME]
) = "Initial response" , "Failed VOE" )
let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
write the following calculated column :
cc =
if(
(tbl[PHASE NAME] = "Verification of Effectiveness" || tbl[PHASE NAME] = "Verification of Effectiveness approval") &&
selectcolumns(
offset ( 1 ,
summarize ( tbl , tbl[PHASE NAME] , tbl[PHASE TICK_ID-1]) ,
orderby( tbl[PHASE TICK_ID-1] , asc )
),
"@PHASE NAME" , tbl[PHASE NAME]
) = "Initial response" , "Failed VOE" )
let me know if that works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
modify to this :
cc =
if(
(tbl[PHASE NAME] = "Verification of Effectiveness" || tbl[PHASE NAME] = "Verification of Effectiveness approval") &&
selectcolumns(
offset ( 1 ,
summarize ( tbl , tbl[PHASE NAME] , tbl[PHASE TICK_ID-1]) ,
orderby( tbl[PHASE TICK_ID-1] , asc ) ,
PARTITIONBY(tbl[INTERNAL_AUDIT_RESPONSE_NUMBER])
),
"@PHASE NAME" , tbl[PHASE NAME]
) = "Initial response" , "Failed VOE" )
let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
i have added Phase Name to the summarize table as well. with that it works perfectly!! amazing, thank you!!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
104 | |
87 | |
35 | |
35 |
User | Count |
---|---|
152 | |
98 | |
81 | |
61 | |
55 |