Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Ya'll,
I have these 2 formulas:
Calculated Column
Solved! Go to Solution.
@Anonymous ,
You can nor measure in a column.
Try a measure like this
PSU =
sumx(Values(LTIP[Management Level]) ,
Switch(
True(),
max(LTIP[Management Level]) IN {"5B","5A","4B","4A","3"},ROUNDDOWN([LTIP Shares]*.25,0),
max(LTIP[Management Level]) IN {"2","1","0"},ROUNDDOWN([LTIP Shares]*.50,0),
Blank()
))
@Anonymous ,
You can nor measure in a column.
Try a measure like this
PSU =
sumx(Values(LTIP[Management Level]) ,
Switch(
True(),
max(LTIP[Management Level]) IN {"5B","5A","4B","4A","3"},ROUNDDOWN([LTIP Shares]*.25,0),
max(LTIP[Management Level]) IN {"2","1","0"},ROUNDDOWN([LTIP Shares]*.50,0),
Blank()
))
Doh! You're right!
Thanks so much! I appreciate your help here!