Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
How can this measure be modified to subtract 21 if LOT NUM >5 but not equal to 8
Solved! Go to Solution.
You can use SWITCH function
A pattern like following
= VAR myvalue = SELECTEDVALUE ( vw_ShiftsAll[LOT Num] ) RETURN SWITCH ( TRUE (), myvalue > 6 && myalue <> 8, [Formula1], [Formula2] )
Try
Avg Hrs Var = CALCULATE ( [Average Hrs Worked] - 21, vw_ShiftsAll[LOT Num] > 5 && vw_ShiftsAll[LOT Num] <> 8 )
Hi,
Thks for the reply.
I was looking to combine the 2.
Something like:
If LOT Num <= 5 & <> 9 then subtract 23
else if LOT Num > 5 & <> 8 then subtract 21.
You can use SWITCH function
A pattern like following
= VAR myvalue = SELECTEDVALUE ( vw_ShiftsAll[LOT Num] ) RETURN SWITCH ( TRUE (), myvalue > 6 && myalue <> 8, [Formula1], [Formula2] )
Yeah, that work perfectly. Thanks a million.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |