To do basic calculation and data analysis on data in power pivot, we use Data Analysis Expression (DAX). It is 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.
Sample DAX formula syntax:
For the measure named Total Sales, calculate (=) the SUM of values in the [SalesAmount] column in the Sales table.
Posted Date:- 2021-09-27 05:44:00