DAX Fridays! #3: SUM and SUMX

Dax Fridays! Today we will go through: how to use SUM() and SUMX(), the difference between them and when should we use one vs the other.

The DAX SUM function calculates the sum of all numbers in a column while the DAX SUMX function returns the sum of an expression for each row in a table.

02:28 Create a measure to calculate the total sales using SUMX function
03:40 Create a calculated column for total sales (row by row)
05:16 Create a measure to calculate the total sales using SUM function
06:00 Difference between SUM and SUMX

Link to Curbal Glossary: https://curbal.com/blog/glossary/SUM-dax

PREVIOUS VIDEO:    • DAX Fridays! #2: CALENDAR, CALENDARAUTO  
NEXT VIDEO:    • DAX Fridays! #4: COUNT, COUNTA, COUNT...  

For this you need the Northwind dataset:    • Northwind data source: A great online...  

or you can download our example HERE: https://curbal.com/blog/glossary/sum-dax
https://curbal.com/blog/glossary/sumx...

Keynotes:
Northwind datasource 01:44
SUMX 02:39
SUM 04:45
Calculated column vs measure 06:44


Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

Our PLAYLISTS:
Join our DAX Fridays! Series: https://goo.gl/FtUWUX
Power BI dashboards for beginners: https://goo.gl/9YzyDP
Power BI Tips & Tricks: https://goo.gl/H6kUbP
Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
► Linkedin: https://goo.gl/3VW6Ky

#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP