multiple if statement

[FatBlackCat30]

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

[amitchandak]

Can explain with some data and example

[VasTg]

@FatBlackCat30 

I couldn't follow the if statement.

Could you provide a sample input and expected output?

[FatBlackCat30]

@VasTg 

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

[VasTg · Accepted solution]

@FatBlackCat30 

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

[Anonymous]

Here you go. Try this and let me know

Outcome = IF(OR('Table'[Load] = "Both", 'Table'[Count] > 1), "Both", 'Table'[Load])