In this video, we’ll continue learning more about DAX and will build a few basic functions.
Let’s focus on the syntax of the language. Take a look at the formula:
Name of a calculation = SUM (Table Name [Column Name in the Table])
The above formula equals to the sum of a column in a table. For example, it could be the measure named Total Quantity, which equals to the sum of the column Quantity in a sales table.
Every DAX formula starts with the equal sign, similar to an Excel formula, followed by some function name, such as SUM, COUNT, AVERAGE and etc. After the function, a table’s name is referenced and then finally a column. The intelligent autofill function is quite helpful when choosing between tables and columns, one has to simply press the TAB key to select a right choice.
There are over 200 DAX functions and operators in Power BI. Have no fear, however, as the knowledge of around 30 functions should be good enough to do everything you need in a report in most cases, especially as a business user.
One could divide DAX functions into five major categories – math & statistics, logical, text, filter, and date & time functions. Most of these functions will look familiar to Excel users. Even if they are written differently in DAX, their logic they are same. That is why, Excel users should grasp DAX pretty quickly.