Forum Discussion
Solved
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...
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!:-)
Zubair_Muhammad
Community Champion
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