What is DAX and where it is used in Power BI?

1.	What is DAX and where it is used in Power BI?
Answer» DAX is the language of Power BI. It STANDS for Data Analysis Expressions. It is a functional language much like the Excel formulas. Power BI PRODUCT team created DAX by mashing up “Excel formula Language”, “SQL Language” and “MDX Language” DAX is Simple, but it’s not easy. Do not TRY to learn It in the usual way. You need to spend time to understand hard parts. E.g. Syntax elements: Name of Measure is “Total Sales”. operator (=) equals sign implies its beginning of the formula and returns the result. Adds up all of the numbers in the COLUMN Sales[SalesAmount] using SUM Function All functions require one or more argument surrounded by Parenthesis () Name of Table “Sales” The column [SalesAmount] in the Sales table and SUM function is used to AGGREGATE Sales.

Answer»

DAX is the language of Power BI. It STANDS for Data Analysis Expressions. It is a functional language much like the Excel formulas.

Power BI PRODUCT team created DAX by mashing up “Excel formula Language”, “SQL Language” and “MDX Language”

DAX is Simple, but it’s not easy. Do not TRY to learn It in the usual way. You need to spend time to understand hard parts.

E.g.

Syntax elements:

Name of Measure is “Total Sales”.
operator (=) equals sign implies its beginning of the formula and returns the result.
Adds up all of the numbers in the COLUMN Sales[SalesAmount] using SUM Function
All functions require one or more argument surrounded by Parenthesis ()
Name of Table “Sales”
The column [SalesAmount] in the Sales table and SUM function is used to AGGREGATE Sales.

Discussion