Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Fidzi8
Helper IV
Helper IV

fc. IF + more conditions

Hi,I donť know how insert more conditions?

.2020-08-06_10h24_34.png

Thank you

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Fidzi8 

you can use

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

Other Option

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

View solution in original post

mahoneypat
Employee
Employee

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

 

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
mahoneypat
Employee
Employee

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

 

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


amitchandak
Super User
Super User

@Fidzi8 

you can use

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

Other Option

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

Hi, 
is this good? 


2020-08-06_12h55_09.png
I don´t want to write for each number new IF.

Thank you
Ondřej

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.