Need to calculate rejection rate

[KOLD1313]

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 display the rejection rate. There are some month that I dont have production or rejects.

 Example

 

 

[Anonymous · Accepted solution]

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.

[KOLD1313]

Thank you!

[Omid_Motamedise]

You can merge the tables together in Power Query

if you want more help, please provide your data sample here as table