Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
moatazezat
Helper I
Helper I

Dax Function to repeated certain Number

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

 

 

Dax Function to repeated certain Number.png

 

 

 

 

https://drive.google.com/file/d/1hlBrUVfDDeWLX-ZSmOCug-dcXhoSgQfH/view?usp=sharing

 

 

 

5 REPLIES 5
Anonymous
Not applicable

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

 

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors