How to Create a Column that Summarizes the Others

Hi SydneyAM ,

Based on the description, please try the following methods:

1.Create the sample table.

2.Open the power query editor, select add custom column. Enter the following formula.

if [Result] = "fail" then
         if [Ship to] = "fail" then "Ship to failed" else
         if [Qty] = "fail" then "Qty failed" else
         if [Selling Price] = "fail" then "Selling Price failed" else
         if [First Date] = "fail" then "First Date failed" else
         "Other reason"
       else
         "pass"

3.Select ok. The result is shown below.

4.Close and apply. Drag the fields to the column chart.

Best Regards,

Wisdom Wu

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