True/False based on Multiple Column Conditions

[JP_Caterpillar]

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 due. There are 3 steps ICA, RCCA, and PCA for one document number. That can show past due "Not Complete" and "Past Due". Filtering does not seem to calculate correctly. 

I have tried a few suggestions that I have found and nothing seems to be working. This is what I am working with right now. 

NCR Past Due = Calculate(True(),('Audit Findings Data','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")

[v-henryk-mstf · Accepted solution]

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.

[JP_Caterpillar]

Thank you Henry, I did not get a chance to try this but it does seem to work. We actually might have achieved the same goal just more complicated by creating 3 new columns and collecting the columns if they had value to get the count using the the Switch to function to get the card to populate the number based off the 6 conditions being met.  I am going to mark this as Accept as Solution because it seems like a lot less steps to get the job done. Appreciate your Help! 

Then the switch to

Then I was able to perform a count on the ones that were past due. 

 

[v-henryk-mstf]

Hi @JP_Caterpillar ,

Very honored to be able to help you.😊

Best Regards,

Henry

[Vera_33]

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"