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 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")
