What is Data Analysis Expressions (DAX)?

Data Analysis Expressions aka DAX allows you to calculate, create and return information on your data. Using DAX enables you to add more context to your original data to perform better analysis and get more meaning from your data.

DAX formulas are similar to writing functions in Excel and can be used in Analysis Services, Power BI, or Power Pivot in Excel.

Data Analysis Expressions formulas can be used to create measures, calculated columns, calculated tables or filter rows.

For examples of how to build Analysis Services Tabular models and leverage DAX see my book.

Learn more about Data Analysis Expression DAX:

Measures calculate a specific value based on the data such as Total Sales:=SUM([Sales Amount])

Calculated Columns are added to your data for row in the dataset such as =[Calendar Year] & " Q" & [Calendar Quarter]

Calculated Tables create a new table based on data or formulas in your dataset such as NewDateTable = CALENDAR (DATE (2005, 1, 1), DATE (2015, 12, 31))

Row Level Security determine what data users can see if required. For example =Customers[Country] = "USA" would filter the data for the sales team that has USA.

NEED TO SPEAK TO US?

Live Chat

832-819-5744

sales@cdoadvisors.com

DO YOU NEED HELP WITH DATA ANALYSIS EXPRESSIONS DAX or POWER BI?

Send us a message and we'll answer any query you may have

Calculate Customer Churn ROI

Decrease the number of customers that churn from your company by learning the leading drivers of churn. To learn how much a customer churn model can increase your revenue use the calculator below.

Calculate Cross Sell ROI

Maximize your marketing spend by sending your campaigns to the customers most likely to accept your offer. To see the impact of a cross sell campaign use the calculator below.