Forum Discussion

Fidzi8's avatar
Fidzi8
Icon for Helper V rankHelper V
6 years ago
Solved

fc. IF + more conditions

Hi,I donť know how insert more conditions? . Thank you
  • amitchandak's avatar
    6 years ago

    Fidzi8 

    you can use

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

    Other Option

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

  • mahoneypat's avatar
    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