Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Dears,
I need your help,
In Power Pivot, I need to calculate the Ingredient cost Divid Period Qty and appear in the Period Qty Column.
https://drive.google.com/file/d/1hlBrUVfDDeWLX-ZSmOCug-dcXhoSgQfH/view?usp=sharing
Hi @moatazezat ,
Are you able to provide more details with your desired output and pbix file without privacy information (or some sample data) ? I can't properly understand what you mean.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
you will continue with me.
How Can I attache the file?
Yes of course, How Can I
We produce 2 Products in Line (YP2) and 4 Products in Line (YP3)
Production Qty appears Under Period Cost Like (21,123)
I need to Know How much per Ton for proucts.
Source
1-Ingredients-In (Qty + Cost)
Total Cost / Period Cost (Qty) 21,123 = Average Cost
2- Period Cost (Qty + Cost)
Total Cost / Period Cost (Qty) 21,123 = Average Cost
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.