Forum Discussion
DAX formula help for multiple IF statements
Hi i am trying to create banding for with the following statement; if [NumberOfUsers] <250 then "SME" else if [NumberOfUsers] >=250 <=1000 then "Corporate" else if ([NumberOfUsers] >=1000 <=5000 ...
am getting an error when doing this ;
The syntax for ';' is incorrect. (DAX(SWITCH(TRUE();[NumberOfUsers] < 250 ; "SME";[NumberOfUsers] < 1000 ; "Corporate";[NumberOfUsers] < 5000 ; "Enterprise";[NumberOfUsers] >= 5000 ; "Global";BLANK)).
CrisYan
Resolver III
Resolver IIIReplace all ';' for ','.
(My PBI Desktop are with ';', yours must be with ',')
is there something i am missing to get this error;
The value for 'userband' cannot be determined. Either 'userband' doesn't exist, or there is no current row for a column named 'userband'.
v-juanli-msftCommunity Support
Hi Anonymous
Use this formula
measure =
IF (
[NumberOfUsers] < 250,
"SME",
IF (
[NumberOfUsers] >= 250
&& [NumberOfUsers] <= 1000,
"Corporate",
IF ( [NumberOfUsers] > 1000 && [NumberOfUsers] <= 5000, "Enterprise", "Global" )
)
)I can't see 'userband' from all above, where do you use 'userband'?
Best Regards
Maggie