Use the SUMX Function in Power Pivot

This video will cover a simple case of how to use the SUMX DAX function. You can think of it as a cousin to the SUMPRODUCT function, but more powerful when using it in PowerPivot. In addition, I'll cover another example of how it can be used to enable to calculate the correct total averages for an example data set. See the video to learn more.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@sasavienne]

Thanks a lot. 👍 🌟 💯 Likes.. 🌟

[@DougHExcel]

You're Welcome!

[@irfanbashir1314]

Thanks! Sir how can we confirm 3.49 is wrong average?

[@DougHExcel]

In this example we are looking at the weighted average for this table and that's why I labeled it as the wrong value to use. If we were ONLY looking at the average of the prices (and not taking in consideration of the quantity), then 3.49 is correct.

[@irfanbashir1314]

@@DougHExcel Thanks sir! It would have been clear with simple numbers as i wonder if excel average formula gives wrong results. Thanks for your work. Great job!

[@DougHExcel]

Doug H
• 22 minutes ago
You're Welcome!