Forum Discussion
Solved
Need to calculate rejection rate
I have to tabs on Power Query from excel data. One of the tab had the monthly production of 5 items. The other tab had the rejects per those 5 items I neeed to create a control chart to be able to di...
Hi KOLD1313 ,
Here is my sample data:In Power Query, merge these two tables as a new one:
Expand the column:
Add a custom column:
if [rejects] = null then 0 else ([rejects] / [quantity])And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi KOLD1313 ,
Here is my sample data:
In Power Query, merge these two tables as a new one:
Expand the column:
Add a custom column:
if [rejects] = null then 0 else ([rejects] / [quantity])
And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!