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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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