Forum Discussion
Post PatronHelp with IF statement
HI OPS-MLTSD
You need to revisit the range of 'IHSP - work plan'[3-Yr LTI per 100]
as per your formula
>=5 High <1 Low >=1(is it 'and <2'?????) Medium >=2 to <5(Ths range is not present) ???????(lets assume Medium High) Try this
3 Yr LTI Risk = IF('IHSP - work plan'[3-Yr LTI per 100] >=5, "High",
IF('IHSP - work plan'[3-Yr LTI per 100] <1, "Low",
IF('IHSP - work plan'[3-Yr LTI per 100] >=1 && 'IHSP - work plan'[3-Yr LTI per 100] <2, "Medium",IF('IHSP - work plan'[3-Yr LTI per 100] >=2 && 'IHSP - work plan'[3-Yr LTI per 100] <5,"Medium High",
"Not Available")
)
)
)
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Community SupportHi, OPS-MLTSD
Based on your description, I created data to replace your scenario. The pbix file is attached in the end.
IHSP - work plan:
You may create a calculated column as below.
Result =
SWITCH(
TRUE(),
[3-Yr LTI per 100]<1,"Low",
[3-Yr LTI per 100]>=1&&[3-Yr LTI per 100]<2,"Medium",
[3-Yr LTI per 100]>=2&&[3-Yr LTI per 100]<5,"Not Available",
[3-Yr LTI per 100]>=5,"High"
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.