cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User IV
Super User IV

@Fidzi8 

you can use

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

Other Option

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Super User IV
Super User IV

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
Super User IV
Super User IV

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

Super User IV
Super User IV

@Fidzi8 

you can use

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

Other Option

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors