Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Weighted Average

Hi, I am trying to find a way to calculate a weighted average weight per month considering the weight and volume per item per month per plant. For some reason, I cannot manage to make a measure that ...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ashish_Mathur 

 

Thanks a lot Ashish this helps! I am just wondering can the denominator calculation be built as a measure instead? I have been told that the adding column feature run slowlier than a measurement. 

 

Looking forward to hearing from you!

 

Thanks again!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    You are welcome.  That will take a ot of time.  Please plug in your actual data here and let me know whether everything is working fine for you or not.