Skip to main content
cancel
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

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
v-rongtiep-msft
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.

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
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.