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 September 15. Request your voucher.
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
User | Count |
---|---|
70 | |
67 | |
62 | |
48 | |
28 |
User | Count |
---|---|
113 | |
77 | |
65 | |
55 | |
43 |