Forum Discussion
Function SWITCH TRUE doesn't work
Hi!
I need some help.
I use the SWITCH function but with the same number, i don't have the same result and i don't known why.
SWITCH(
TRUE(),
M <= 100 , "1",
M <=500, "2",
M <=1000, "3",
M <=1500, "4",
M> 1500,"5"
)
TRUE(),
M <= 100 , "1",
M <=500, "2",
M <=1000, "3",
M <=1500, "4",
M> 1500,"5"
)
I try with IF too but i got the same result :
IF(
M <= 100 , "1",,
IF(
M <=500, "2",
IF(
M <=1000, "3",
IF(
M <=1500, "4",
IF(
M> 1500,"5"
)
)
)
)
)
M <= 100 , "1",,
IF(
M <=500, "2",
IF(
M <=1000, "3",
IF(
M <=1500, "4",
IF(
M> 1500,"5"
)
)
)
)
)
For the first line M = 1170,58 but the result is 4 and the second line M = 1170,40 but the result is 3.
I really don't understand why it doesn't work.
5 Replies
Anonymous ,Both seems fine, If you are using a measure this should work fine as measure and if you using a column (M) this work fine as new column
SWITCH(
TRUE(),
[M] <= 100 , "1",
[M] <=500, "2",
[M] <=1000, "3",
[M] <=1500, "4",
[M] > 1500,"5"
)
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Anonymous , can check the data type or M, it should be number - Decimal ?
