Forum Discussion
multiple if statement
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 nullYour 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
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 |
Here you go. Try this and let me know
Outcome = IF(OR('Table'[Load] = "Both", 'Table'[Count] > 1), "Both", 'Table'[Load])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 nullYour 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