Forum Discussion
fc. IF + more conditions
- 6 years ago
- 6 years ago
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
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