DAX SUM and SUMX functions

DAX for Power BI and Power Pivot – SUM and SUMX Functions

The role of both the SUM and SUMX functions in DAX are to add numerical data together.  Yet both these functions are rather different.Lets talk about the SUM function first.  The SUM function is simple.  It takes a column of data and adds the values to give a total.  The syntax is SUM().  It works like the […]

DAX Divide Function

DAX for Power BI and Power Pivot – DAX Divide Function

When you are working in Excel it is relatively easy to divide two numbers. You take the value from one cell, and divide it by the value or the in another cell.  For Example =B3/B2.  Divide is a basic mathematical operator. In Excel if you try to divide a value by zero you will get the error […]