fc. IF + more conditions

[Fidzi8]

Hi,I donť know how insert more conditions?

.

Thank you

[amitchandak · Accepted solution]

@Fidzi8 

you can use

in {"Ab","BC","BC"}

Other Option

[COl1] ="A" || [COl2] ="B"

[mahoneypat · Accepted solution]

If you are going to list the values that way, you need to use IN instead of "=".  I assume this is for a calculated column.

NewColumn = IF(REP_1[SPZ] IN {"SE3 910", "SE8 4164"}, ...

An easier way for you to do this might be to use the Groups column features, so no DAX will be required and it will be easy to adapt in the future.  Please see this link.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[amitchandak · Accepted solution]

@Fidzi8 

you can use

in {"Ab","BC","BC"}

Other Option

[COl1] ="A" || [COl2] ="B"

[Fidzi8]

Hi, 
is this good? 

I don´t want to write for each number new IF.

Thank you
Ondřej