Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |