Last Updated on: 21st April 2024, 08:15 am
In DAX, there are several types of expressions and functions that you can use to manipulate and analyze data. Here are some of the main types:
1. **Calculated Columns**: These are columns that you add to a table in Power BI or Power Pivot by defining a DAX expression. The expression is evaluated row by row to compute the value for each row in the column.
2. **Measures**: Measures are calculations that are performed on the fly, typically in response to user interactions, such as filtering or slicing data in a report. Measures are often used to calculate aggregations, such as sums, averages, counts, or percentages.
3. **Calculated Tables**: Similar to calculated columns, calculated tables are created using DAX expressions. However, instead of adding a column to an existing table, a calculated table creates an entirely new table based on the expression.
4. **Filtering and Iterating Functions**: DAX includes a variety of functions for filtering and iterating over data, such as FILTER, CALCULATE, and SUMX. These functions allow you to dynamically filter data, apply conditions, and perform calculations over subsets of data.
5. **Statistical Functions**: DAX provides statistical functions for performing calculations such as mean, median, standard deviation, variance, and correlation.
6. **Time Intelligence Functions**: DAX includes a set of functions specifically designed for working with dates and times, such as TOTALYTD, SAMEPERIODLASTYEAR, and DATESBETWEEN. These functions are commonly used for analyzing trends over time and performing year-to-date calculations.
7. **Text Functions**: DAX includes functions for working with text data, such as concatenating strings, extracting substrings, converting text to uppercase or lowercase, and searching for specific patterns within text.
These are just a few examples of the types of expressions and functions available in DAX. The language is quite rich and versatile, allowing for a wide range of data manipulation and analysis tasks.
