Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
Regards,
Daniel He
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.
Regards,
Daniel He
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |