IF with Multiple Condition

[AllanBerces]

Hi Good day,

Can anyone pls need assistance on how can i get the result i need.

 - The Period should equal to Q1

 - The Location is under EAST and SOUTH only

 - For SOUTH Location, the Priority should contain 1 only.

DESIRED OUTPUT

Thank you

[rajulshah · Accepted solution]

Hello @AllanBerces ,

Please try following DAX formula in calculated column and please let me know if you face any issues.

RESULT =
IF (
    [Period] = "Q1",
    IF (
        [Location] = "EAST"
            || (
                [Location] = "SOUTH"
                    && SEARCH ( "1", [Priority], 1, BLANK () ) = 1
            ),
        [Project/Mntc],
        "EXCLUDED"
    ),
    "EXCLUDED"
)

[bhanu_gautam · Accepted solution]

@AllanBerces Create a new column to determine if the row meets the conditions

DAX

Result =

IF (

    'Table'[Period] = "Q1" &&

    (

        'Table'[Location] = "EAST" ||

        (

            'Table'[Location] = "SOUTH" &&

            LEFT('Table'[Priority], 1) = "1"

        )

    ),

    'Table'[Project/Mntc],

    "Excluded"

)

[rajulshah · Accepted solution]

Hello @AllanBerces ,

Please try following DAX formula in calculated column and please let me know if you face any issues.

RESULT =
IF (
    [Period] = "Q1",
    IF (
        [Location] = "EAST"
            || (
                [Location] = "SOUTH"
                    && SEARCH ( "1", [Priority], 1, BLANK () ) = 1
            ),
        [Project/Mntc],
        "EXCLUDED"
    ),
    "EXCLUDED"
)

[AllanBerces]

Hi @bhanu_gautam @rajulshah Thank you very much for the help. Working perfectly.