Forum Discussion
True/False based on Multiple Column Conditions
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.
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.
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.
 
