Power BI: basic DAX functions

Опубликовано: 23 Октябрь 2024
на канале: Nik Pavlov
145
4

DAX syntax is the following:

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.

Every DAX formula starts with the equal sign, similar to an Excel formula, followed by a function, such as SUM, COUNT, AVERAGE, and etc. After the function, a table’s name is referenced, followed by a column's name.

One could divide DAX functions into five major categories:
1. Math & statistics
2. Logical
3. Text
4. Filter
5. Date & time functions

To learn more about Power BI: https://centida.com/index.php/blog/

#PowerBI #DAX #syntax