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.
Hello all,
I have two columns: load and count.
I would like to create a new calculated column called "Class" with formula logic like this:
-if count > 1 then "Both" , load
or if load = "Both" then "Both
I am getting lost on how to use two differnet logical outcomes.
thanks for the help
Solved! Go to Solution.
Create a custom column in query editor and use the below formula.
if [Count]>1 or [Load] = "Both" then "Both" else if [Load] <> "Both" and [Count]<=1 then [Load] else null
Your 3rd point states "and the count is < 1" but the example show "count <= 1". So modify the above code as per your need.
If this helps, mark it as a solution
Kudos are nice too
Can explain with some data and example
I couldn't follow the if statement.
Could you provide a sample input and expected output?
1. if load says "Many" the outcome should be "Many"
2. but if the count is > 1 the outcome should be "both"
3. but if the load does not = "both" and the count is <1 then the outcome should be the load column
Load | Count | Load | Count | Outcome | |
Both | 1 | Many | 1 | Many | |
Cat | 2 | Cat | 2 | Both | |
Dog | 2 | Dog | 2 | Both | |
Car | 1 | Car | 1 | Car | |
Both | 2 | Many | 2 | Many | |
Bottle | 2 | Bottle | 2 | Both | |
Board | 1 | Board | 1 | Board | |
Phone | 1 | Phone | 1 | Phone | |
Tree | 1 | Tree | 1 | Tree |
Create a custom column in query editor and use the below formula.
if [Count]>1 or [Load] = "Both" then "Both" else if [Load] <> "Both" and [Count]<=1 then [Load] else null
Your 3rd point states "and the count is < 1" but the example show "count <= 1". So modify the above code as per your need.
If this helps, mark it as a solution
Kudos are nice too
Here you go. Try this and let me know
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |