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

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

PBI_APRIL_CAROUSEL1

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.