What is DAX

What is DAX (DATA ANALYSIS EXPRESSIONS)

Data Analysis Expression language or DAX, was originally released with Power Pivot in Excel in 2010 by Microsoft. It’s a functional language that is very similar to excel, as you would expect as it was part of the excel tools.  Its initial basic function was to allow excel users solve more complex business problems.Now, not […]

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 […]