Forum Discussion
SWITCH DAX error
The formula below is not working for some reason.. Can somebody help correct me? SWITCH ( TRUE, [Days] < 30, "<30 Days", [Days] >= 30 && [Days] <= 69, "30-69 Days", [Days] >= 70 && [Days] <= ...
Anonymous
maybe try this
SWITCH (
TRUE(),
[Days] < 30, "<30 Days",
[Days] <= 69, "30-69 Days",
[Days] <= 100, "70-100 Days",
[Days] <= 140, "101-140 Days",
[Days] <= 180, "141-180 Days",">180 Days")
Anonymous
maybe try this
SWITCH (
TRUE(),
[Days] < 30, "<30 Days",
[Days] <= 69, "30-69 Days",
[Days] <= 100, "70-100 Days",
[Days] <= 140, "101-140 Days",
[Days] <= 180, "141-180 Days",">180 Days")