Forum Discussion

Kaalbartje2's avatar
Kaalbartje2
Frequent Visitor
3 years ago
Solved

Nested IF in Dax or M

Hello,   I searched but I couldn't find the solution what my problem is. I have different department in a column and I have a specialism in another. I want to specify when a specialism is wrong i...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Kaalbartje2 ,

    Please have a try.

    Create a column.

    column = 
IF (
    'table'[department] = "Department A"
        && 'table'[specialism] = "cardio",
    TRUE (),
    IF (
        'table'[department] = "Department B"
            && ( 'table'[specialism] = "cardio"
            || 'table'[specialism] = "pulmo" ),
        TRUE (),
        IF (
            'table'[department] = "Department C"
                && ( 'table'[specialism] = "pulmo"
                || 'table'[specialism] = "KNO"
                || 'table'[specialism] = "anest" ),
            TRUE (),
            FALSE ()
        )
    )
)

    If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

latimeria's avatar
latimeria
Icon for Solution Specialist rankSolution Specialist
3 years ago

hi Kaalbartje2 ,

I don't understand what you want.

Do you want to build a table with valid departments / specialsms and check whether it is correct in your transactions?

Kaalbartje2's avatar
Kaalbartje2
Frequent Visitor
3 years ago

Hello,

 

Tnx for looking to my question.

I want to make a new column with true or false. When the specialism doesn't match the department it's a false. A true when they do match.