Forum Discussion

JP_Caterpillar's avatar
JP_Caterpillar
New Member
5 years ago
Solved

True/False based on Multiple Column Conditions

Good afternoon all,    Was hoping for some assistance. I am currently working on a Power Bi project where I need to specify whether an action is past due based on if any of the other steps are past...
DAX
False
power bi
True
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi JP_Caterpillar ,

    You can add a new column in the power query, try the following formula: 

    = Table.AddColumn(#"Replaced Value", "Custom1", each if [ICA Completed] = "Complete" and [ICA PAST DUE] = "Pass Due" and [RCCA Completed] = "Complete" and [RCCA PAST DUE] = "Pass Due" and [PCA Submitted] = "Complete" and [PAC SUBMISSION PAST DUE] = "Pass Due" then "Ture" else "False")

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi JP_Caterpillar 

 

So it is a calculated column with OR logic? Are you trying to do it?

NCR Past Due =
'Audit Findings Data'[ICA Completed] = "Complete"
    || 'Audit Findings Data'[ICA PAST DUE] = "Past Due"
    || 'Audit Findings Data'[RCCA Completed] = "Complete"
    || 'Audit Findings Data'[RCCA Past Due] = "Past Due"
    || 'Audit Findings Data'[PCA Submitted ?] = "Complete"
    || 'Audit Findings Data'[PCA Submission PAST DUE] = "Past Due"