What is DAX?

To do basic calculation and data analysis on data in power pivot, we use Data Analysis Expression (DAX). It is a formula language used to compute calculated column and calculated field.

 

DAX works on column values.

DAX can not modify or insert data.

We can create calculated column and measures with DAX but we can not calculate rows using DAX.