Multiple IF statement

[Anonymous]

I am trying to do a nested if statement to help me categorise some data in a calculated column

Formula for Calculated colunm just for reference

SUMX ( 'Summary', IF ( ISERROR ( VALUE ( 'Summary'[UPRN] ) ), 1 , BLANK() ) )

The idea is to create these groups based on a numerical value.

0-5 – Up To Five

6-10 Between Six and Ten

10-20 Between Ten and Twenty

30+ Thirty and above

Is an nested if statement the best way to achieve this. I initially tried grouping the data but had little success.

[Mariusz · Accepted solution]

Hi @Anonymous 

You can try SWITCH like below.

Column = 
VAR x = 'Table'[Value]
RETURN 
SWITCH(
    TRUE(),
    x >= 0 && x <= 5, "Up To Five",
    x >= 6 && x <= 10, "Between Six and Ten",
    x >= 10 && x <= 20, "Between Ten and Twenty",
    "30+ Thirty and above"
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.