Forum Discussion
AND IF in conditional column
Hi, I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns. What I'm looking for is something like this: If [COUNT...
Hi,
I need to do an IF(AND statement that has more than 2 AND conditions e.g.
= IF(AND(Table[FieldX] = "1",AND(Table[FieldY] = "2",AND(Table[FieldZ] = "1")
,"True",
"False")
Is this possible in PBI or am I only limited to 2 AND conditions? Is there a workaround anybody knows of?