DAX Functions

Power BI Section

• Introduction
• Getting Started
• Basic Concepts
• Creating Visualizations
• Data Preparation
• DAX Functions
• Advanced Topics
• Power BI Service
• Tips and Tricks
• Updates and News

DAX Functions in Power BI

Data Analysis Expressions (DAX) functions are used in Power BI to perform calculations, manipulate data, and create custom measures and calculated columns. DAX functions can be categorized into several groups based on their functionality and usage. Below are some of the key categories of DAX functions:

• Aggregation Functions: Aggregation functions in DAX are used to perform calculations across multiple rows or columns in a dataset and return a single aggregated value. Common aggregation functions include SUM, AVERAGE, MIN, MAX, COUNT, and DISTINCTCOUNT. These functions are essential for summarizing and analyzing data in Power BI reports and dashboards.
• Filter Functions: Filter functions in DAX are used to filter data based on specific criteria and conditions. These functions include FILTER, CALCULATE, ALL, ALLEXCEPT, VALUES, and TOPN. Filter functions allow you to apply row-level or context-based filters to your data and control the scope of calculations in Power BI visualizations.
• Date and Time Functions: Date and time functions in DAX are used to manipulate and perform calculations on date and time values. These functions include DATE, YEAR, MONTH, DAY, TODAY, DATEADD, DATEDIFF, and EOMONTH. Date and time functions allow you to extract components of dates, calculate date differences, and perform date arithmetic in Power BI.
• Logical Functions: Logical functions in DAX are used to evaluate logical conditions and return TRUE or FALSE values based on the result. These functions include IF, AND, OR, NOT, SWITCH, and XOR. Logical functions are commonly used in conditional calculations, branching logic, and data validation in Power BI measures and calculated columns.
• Mathematical Functions: Mathematical functions in DAX are used to perform mathematical operations and calculations on numerical values. These functions include ROUND, ROUNDUP, ROUNDDOWN, ABS, CEILING, FLOOR, SQRT, and POWER. Mathematical functions allow you to perform basic arithmetic, rounding, and trigonometric calculations in Power BI.
• Statistical Functions: Statistical functions in DAX are used to perform statistical analysis and calculations on data distributions. These functions include AVERAGEIF, AVERAGEIFS, MEDIAN, STDEV, VAR, CORREL, and RANKX. Statistical functions allow you to calculate measures of central tendency, dispersion, correlation, and rank-based metrics in Power BI.
• Text Functions: Text functions in DAX are used to manipulate and perform operations on text strings. These functions include CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, and SUBSTITUTE. Text functions allow you to extract substrings, concatenate strings, format text values, and perform search and replace operations in Power BI.
• Information Functions: Information functions in DAX are used to retrieve information about data types, values, and relationships. These functions include ISBLANK, ISNUMBER, ISTEXT, TYPE, and RELATED. Information functions allow you to perform data validation, error handling, and dependency analysis in Power BI.
• Time Intelligence Functions: Time intelligence functions in DAX are specialized functions used to perform calculations and analysis on date and time dimensions. These functions include TOTALYTD, TOTALMTD, TOTALQTD, SAMEPERIODLASTYEAR, and DATEADD. Time intelligence functions allow you to compare data across time periods, calculate year-to-date metrics, and perform time-based calculations in Power BI.
• Financial Functions: Financial functions in DAX are used to perform financial calculations and analysis, such as present value, future value, and cash flow calculations. These functions include PV, FV, NPV, IRR, and PMT. Financial functions allow you to analyze investment returns, loan payments, and other financial metrics in Power BI.

Analytic Pulse