Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |