Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
you can use
in {"Ab","BC","BC"}
Other Option
[COl1] ="A" || [COl2] ="B"
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
you can use
in {"Ab","BC","BC"}
Other Option
[COl1] ="A" || [COl2] ="B"
Hi,
is this good?
I don´t want to write for each number new IF.
Thank you
Ondřej
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |