I am reposting this becuase I had my logic incorrect beforemultiple if statement 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 = "Many" and the count is <1 then the outcome should be the load column LoadCount LoadCountOutcomeMany1 Many1ManyCat2 Cat2BothDog2 Dog2BothCar1 Car1CarMany2 Many2ManyBottle2 Bottle2BothBoard1 Board1BoardPhone1 Phone1PhoneTree1 Tree1Tree

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

Microsoft Employee

6 years ago

Solved

Re: Multiple if statements

I am reposting this becuase I had my logic incorrect before

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 = "Many" and the count is <1 then the outcome should be the load column

Anonymous
6 years ago
Try

Outcome = IF('Table'[Load] = "Many", "Many", IF('Table'[Count] > 1, "Both", 'Table'[Load]))
JarroVGIT
6 years ago
FatBlackCat30,

Try this:
Column = SWITCH(TRUE(), Table1[Load] = "Many", "Many", Table1[Count] > 1, "Both", Table1[Load])
Result:

Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂