Switch true for min and max range in power bi desktop

I am trying to specify each dimension range (length, width and height) of values specify criteria based on the length, width and height.

In data table I have 3 columns are length, width,height based on the 3 columns I would like to generate status columns which is based on the below mentioned condition range.

Conditions Range

1.Length, width and height is start from 1 to 300 then A1.

2.Length, width and height is start from 301 to 650 then A2.

3.Length, width and height is start from 651 to 900 then A3.

4.Length, width and height is start from 901 to 1200 then A4

5.Length, width and height is start from 1201 above then XXX

Any suggestions please



Read more here: https://stackoverflow.com/questions/67928957/switch-true-for-min-and-max-range-in-power-bi-desktop

Content Attribution

This content was originally published by johon at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: