Forum Discussion
help on simple DAX formula to recode numbers into text
Hi,
How do I create a calculated formula for this.... if the score in value column is equal to 1 or 2 then the formula should return "Low", if the value is 3 then it should return "Moderate", if the value is 4 or 5, then it should return a "High"
Value
1 ----> Low
2 ----> Low
3 ----> Moderate
4 ----> High
5 ----> High
Thank you very much for your help.
You can use this column
Column = SWITCH ( TRUE (), Table1[Value] IN { 4, 5 }, "High", Table1[Value] = 3, "Moderate", Table1[Value] IN { 1, 2 }, "Low", "Unspecified" )Hi,
Try this
=IF(Data[Value]<=2,"Low",IF(Data[Value]=3,"Moderate","High"))
Hope this helps.
thank you very much. It works!:-)
7 Replies
- Zubair_Muhammad
Community Champion
You can use this column
Column = SWITCH ( TRUE (), Table1[Value] IN { 4, 5 }, "High", Table1[Value] = 3, "Moderate", Table1[Value] IN { 1, 2 }, "Low", "Unspecified" )thank you very much. It works!:-)
thank you very much! it works!:-)
afzalphatanResolver I
Really liked the combination of switch and IN operator
- Ashish_Mathur
Super User
Hi,
Try this
=IF(Data[Value]<=2,"Low",IF(Data[Value]=3,"Moderate","High"))
Hope this helps.
thank you very much. This one also works!:-)
Bbrown44Advocate II
Is there a way to do this in query editor?