easy way to categorize data based on ranges

[OH]

I am quite new to PowerBI and all the big data mining stuff.

Yet since some weeks I am trying to ramp my knowledge up.

When typing the subject I looked up all the proposes articles but non was the answer to my (probale easy) usecase.

I am analysing our CAD-Data and have e.g. a column that lists the Volume of a body in the CAD-Data

Now I want to categorize the Data in the sense of:

Volume

01: 0-0.1 l

02: 0.1-0.2 l

03: 0.2-0.5 l

04: 0.5-1.0 l etc. (I guess you get the idea, don't be too strict about >, >=, etc.)

First I tried to do a calulation but I soon gave up when confronted with the M syntax necessary.

I realized I am not a software engineer guy at all 😉

Currently I found the Query Editor function "Conditional Column" to fulfill my needs quite well.

 But I wonder if there is a more easy or comprehensive way.

E.g. the ranges 0-0.1, 0.1-0.2 might be "re-usable" for other dimensions (e.g. mass, length) as well.

Right now I am clicking/typing 10 lines each times I create a new Cond. Column for another.

Any hints (if not too deep "coded") are welcome

[v-danhe-msft · Accepted solution]

Hi @OH,

Based on my test, you could refer to below steps:

Sample data:

Create a calculated column:

Type = IF('Table1'[Value]<=0.1,1,
         IF('Table1'[Value]<=0.2,2,
         IF('Table1'[Value]<=0.5,3,
         IF('Table1'[Value]<=1,4))))

IF you want to adapt to the other column, just modify the column name in the formula(see the [Value] changed to the [Length]).

Type2 = IF('Table1'[Length]<=0.1,1,
         IF('Table1'[Length]<=0.2,2,
         IF('Table1'[Length]<=0.5,3,
         IF('Table1'[Length]<=1,4))))

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/vhcq8xr3p64fodm/easy%20way%20to%20categorize%20data%20based%20on%20ranges....

Regards,

Daniel He

[OH]

Hello Daniel

Thank you as well for the explanations. Someone else has already answered my other post but you open another way of solution.

I will try both and see what is easier.

Best regards

Olaf

[v-danhe-msft]

Hi @OH,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He