help on simple DAX formula to recode numbers into text

[marshall]

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.

[Zubair_Muhammad · Accepted solution]

@marshall

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"
)

[Ashish_Mathur · Accepted solution]

Hi,

Try this

=IF(Data[Value]<=2,"Low",IF(Data[Value]=3,"Moderate","High"))

Hope this helps.

[Bbrown44]

Is there a way to do this in query editor?

[Ashish_Mathur · Accepted solution]

Hi,

Try this

=IF(Data[Value]<=2,"Low",IF(Data[Value]=3,"Moderate","High"))

Hope this helps.

[marshall]

thank you very much. This one also works!:-)

[Zubair_Muhammad · Accepted solution]

@marshall

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"
)

[afzalphatan]

Really liked the combination of switch and IN operator

[marshall]

thank you very much! it works!:-)

[marshall · Accepted solution]

thank you very much. It works!:-)