Forum Discussion
Help needed with DAX Switch Statement multiple columns (Picture included)
Resolve, thanks a lot HotChilli
Hi HotChilli thanks for that but I am not sure what you mean by having a lower and upper limit column capturing the 5 different performance bands, i.e. > 30, >25 and <=30 etc.
Sorry I am new to PowerBI
Regionlowhighgrading
| West | 35 | 1000 | outstanding |
| West | 30 | 35 | vs |
| West | 25 | 30 | s |
| West | 20 | 25 | u |
| West | 0 | 20 | p |
Each row shows lower, upper and the grading