The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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.
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!
You can merge the tables together in Power Query
if you want more help, please provide your data sample here as table