How should I write multiple IF statements in DAX using Power BI Desktop?

Question

I am having a table which consists of user IDs and SecondsToOrder and i am using Multiple IF Statements

UserID      SecondsToOrder
00001       2320
00002       13
00003       389
00004       95
...         ...

Then I have added a new calculated column MinutesRounded and table looks like this

UserID      SecondsToOrder   MinutesRounded
00001       2320             38
00002       13               0
00003       389              12
00004       95               1
...         ...              ...

Then i added a column Lenght which looks like this

UserID      SecondsToOrder   MinutesRounded    Lenght
00001       2320             38               > 15 minutes
00002       13               0                < 1 minute 
00003       389              12               < 15 minutes 
00004       95               1                < 1 minute  

... ... ... ...  

I have used this DAX Statement

Lenght = IF([MinutesRounded]<1,"< 1 minute",IF([MinutesRounded]<15,"<15 minutes", "> 15 minutes")) 

And i got this syntax error

The syntax for '"< 1 minute"' is incorrect. (DAX(IF([MinutesRounded]<1."< 1 minute",IF([MinutesRounded]<15."<15 minutes", "> 15 minutes")))). 

 

Answer 1

Use switch statement

=
SWITCH (
    TRUE (),
    [MinutesRounded] < 1, "< 1 minute",
    [MinutesRounded] < 15, "<15 minutes",
    "> 15 minutes"
)

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.