DAX (Data Analysis Expressions) helps in creating new information from existing information (or) data. The existing information can be at detail level, using DAX we can create information such as aggregated, summarized and so on.

Before implementing DAX, make sure you know the following details:

• DAX works on column values of a Table.

• DAX cannot modify or insert data, that means source data is SAFE.

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

This formula includes the following syntax elements:

A. The measure name

B. The equals sign operator (

C. The DAX function

D. Parenthesis

E. The referenced table

F. The referenced column

• SUM, MIN, MAX, AVG

• COUNTROWS, DISTINCTCOUNT

• IF, AND, OR, SWITCH

• ISBLANK, ISFILTERED, ISCROSSFILTERED

• VALUES, ALL, FILTER, CALCULATE

• UNION, INTERSECT, EXCEPT, NATURALINNERJOIN, SUMMARIZECOLUMNS, NATURALLEFTEROUTERJOIN, ISEMPTY

• MEDIAN, GEOMEAN, DATEDIFF

• VAR (Variables)

How to change default visual settings in Power BI ?

How many types of interactions are there in Power BI ?.

How to implement DAX in Power BI ?

What are the most commonly used DAX functions in Power BI ?

Sample DAX Formula in Power BI.