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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper I
Helper I

Dax Function to repeated certain Number


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





Community Support
Community Support

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.

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

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.