Introduction to DAX Functions

For analysis, we bring data from relational database to PowerPivot window We can create new measures/calculations and show them along with raw calculations on same power pivot window to make analysis more useful.

Suppose relational table has revenue and cost raw measures but we are interested to show gross profit along with revenue and cost then we can create new measure with name as "gross profit" and define calculation for it. We can use vast set of DAX functions to write calculations. You can find entire list of DAX functions in below link: