DAX Full Course | Power BI Topics & Tutorials

📊 DAX Basics and Syntax

Comments within DAX

Learn how to write comments inside DAX code to improve readability and documentation in Power BI.

Variables in DAX

Understand how to use VAR and RETURN to simplify complex DAX calculations in Power BI.

Row and Filter Context

Learn how row context and filter context influence calculations in DAX expressions.

Context Transition in DAX

Understand how CALCULATE triggers context transition in DAX calculations.

Calculated Columns in Power BI

Create calculated columns using DAX formulas to derive new values from existing data.

DAX Query View in Power BI

Explore and test DAX queries using the DAX Query View interface in Power BI.

&& Logical Operator in DAX

Use the logical AND operator to evaluate multiple conditions within DAX expressions.

IN DAX Operator in Power BI

Filter data efficiently using the IN operator with multiple values.

Text Concatenation DAX Operator (&) in Power BI

Combine multiple text values together using the concatenation operator.

OR DAX (||) Operator in Power BI

Evaluate multiple logical conditions using the OR operator in DAX.

Comparison DAX Operator in Power BI

Compare values using operators like =, >, <,>=, and <= in DAX formulas.

Measures in Power BI

Create dynamic calculations that respond to filters and slicers in reports.

Calculated Tables in Power BI

Generate new tables using DAX expressions for advanced modeling scenarios.

🔎 Filter and Context Manipulation Functions

ALL DAX Function

Learn how the ALL function removes filters from tables or columns in Power BI.

CALCULATE DAX Function

Understand how CALCULATE modifies filter context and performs advanced calculations.

FILTER DAX Function

Apply row-level filtering to tables using logical conditions.

ALLSELECTED DAX Function

Return all rows while preserving filters applied in visuals or slicers.

KEEPFILTERS DAX Function

Maintain existing filter context when applying additional filters.

REMOVEFILTERS DAX Function

Clear filters from specified columns or tables during calculations.

ALLEXCEPT DAX Function

Remove all filters except those applied to specified columns.

CALCULATETABLE DAX Function

Evaluate table expressions within modified filter contexts.

SELECTCOLUMNS DAX Function

Create a new table by selecting and transforming specific columns.

ADDCOLUMNS DAX Function

Add calculated columns dynamically to an existing table expression.

📊 Aggregation Functions

SUM DAX Function

Learn how to calculate totals using the SUM function in Power BI DAX.

SUMX DAX Function

Understand how SUMX evaluates expressions row-by-row in DAX.

MIN DAX Function

Return the smallest value from a column in Power BI.

MINA DAX Function

Learn how MINA evaluates numbers, text, and logical values.

AVERAGE DAX Function

Calculate the mean value of numeric columns.

AVERAGEX DAX Function

Use AVERAGEX to evaluate expressions for each row before averaging.

MINX DAX Function

Evaluate an expression across rows and return the minimum value.

MAX DAX Function

Return the largest value from a column in Power BI.

MAXA DAX Function

Evaluate numbers, text, and logical values to find the maximum.

MAXX DAX Function

Return the maximum value after evaluating row-level expressions.

PRODUCT DAX Function

Multiply values from a column to return the product.

PRODUCTX DAX Function

Evaluate expressions row-by-row and return the product.

⚙️ Logical and Conditional Functions

IF DAX Function

Apply conditional logic in Power BI using the IF function.

SWITCH DAX Function

Evaluate multiple conditions using the SWITCH function.

AND DAX Function

Combine multiple logical conditions in DAX expressions.

TRUE DAX Function

Return a logical TRUE value in DAX expressions.

FALSE DAX Function

Return a logical FALSE value in Power BI calculations.

NOT DAX Function

Reverse logical conditions in DAX formulas.

COALESCE DAX Function

Return the first non-blank value from multiple expressions.

ISLOGICAL DAX Function

Check whether a value is logical TRUE or FALSE.

ISTEXT DAX Function

Determine whether a value is stored as text.

OR DAX Function

Return TRUE if any logical condition evaluates to TRUE.

BLANK DAX Function

Return a blank value in Power BI expressions.

ISBLANK DAX Function

Check whether a value is blank in DAX.

🔤 Text Functions

SEARCH DAX Function

Learn how the SEARCH function locates text within another text string in Power BI DAX.

FIND DAX Function

Understand how FIND searches for text with case sensitivity in DAX.

LEFT DAX Function

Extract characters from the beginning of a text string using LEFT.

RIGHT DAX Function

Return characters from the end of a text string in Power BI.

LOWER DAX Function

Convert text values into lowercase format.

UPPER DAX Function

Transform text values into uppercase letters.

TRIM DAX Function

Remove extra spaces from text except single spaces between words.

LEN DAX Function

Calculate the total number of characters in a string.

VALUE DAX Function

Convert text representations of numbers into numeric values.

CONTAINSSTRING DAX Function

Check whether a string contains a specific substring.

CONCATENATE DAX Function

Join two text strings together in Power BI.

SUBSTITUTE DAX Function

Replace specific text within a string with new text.

REPLACE DAX Function

Replace characters in a string based on their position.

MID DAX Function

Extract characters from the middle of a text string.

EXACT DAX Function

Compare two text values and check if they are exactly the same.

REPT DAX Function

Repeat text multiple times using the REPT function.

CONCATENATEX DAX Function

Concatenate values across rows using expressions.

COMBINEVALUES DAX Function

Combine multiple column values into a single string.

📅 Date and Time Functions

TODAY DAX Function

Return the current date in Power BI using the TODAY function.

NOW DAX Function

Retrieve the current date and time in Power BI.

NEXTDAY DAX Function

Return the next day relative to a given date context.

NEXTMONTH DAX Function

Return the first date of the next month in the current context.

NEXTQUARTER DAX Function

Calculate the next quarter based on the selected date context.

NEXTYEAR DAX Function

Return dates from the next year based on the current filter context.

DATESINPERIOD DAX Function

Return a set of dates within a specified period.

ENDOFMONTH DAX Function

Return the last date of the month in the current context.

ENDOFQUARTER DAX Function

Return the last date of the current quarter.

ENDOFYEAR DAX Function

Return the last date of the year in the current context.

EOMONTH DAX Function

Return the last day of a month relative to a start date.

QUARTER DAX Function

Extract the quarter number from a date.

SAMEPERIODLASTYEAR DAX Function

Return dates from the same period in the previous year.

PARALLELPERIOD DAX Function

Return dates shifted by months, quarters, or years.

WEEKDAY DAX Function

Return the weekday number for a given date.

DATEADD DAX Function

Shift dates forward or backward in time.

PREVIOUSDAY DAX Function

Return the previous day relative to the current filter context.

PREVIOUSMONTH DAX Function

Return dates from the previous month.

PREVIOUSQUARTER DAX Function

Return the dates from the previous quarter.

PREVIOUSYEAR DAX Function

Return the dates from the previous year in the current context.

DATESBETWEEN DAX Function

Return dates between a start date and end date.

DAY DAX Function

Extract the day number from a date value.

MONTH DAX Function

Return the month number from a date.

YEAR DAX Function

Extract the year from a date value.

CALENDAR DAX Function

Create a calendar table using a start date and end date.

STARTOFMONTH DAX Function

Return the first date of the month in the current context.

STARTOFQUARTER DAX Function

Return the first date of the current quarter.

STARTOFYEAR DAX Function

Return the first date of the current year.

NETWORKDAYS DAX Function

Calculate working days between two dates excluding weekends.

OPENINGBALANCEMONTH DAX Function

Return the opening balance for the first date of the month.

OPENINGBALANCEQUARTER DAX Function

Return the opening balance for the quarter.

OPENINGBALANCEYEAR DAX Function

Return the opening balance for the year.

CLOSINGBALANCEMONTH DAX Function

Return the closing balance value for the last date of the month.

CLOSINGBALANCEQUARTER DAX Function

Calculate the closing balance for the last date of a quarter.

CLOSINGBALANCEYEAR DAX Function

Return the closing balance value for the last date of the year.

DATE DAX Function

Create a date value using year, month, and day parameters.

EDATE DAX Function

Return a date shifted by a specified number of months.

DATESMTD DAX Function

Return a table of dates for the month-to-date period.

DATESQTD DAX Function

Return dates from the beginning of the quarter to the current date.

DATESYTD DAX Function

Return dates from the beginning of the year to the current context date.

TOTALMTD DAX Function

Calculate month-to-date totals for a given expression.

TOTALQTD DAX Function

Calculate quarter-to-date totals using DAX expressions.

TOTALYTD DAX Function

Calculate year-to-date totals for a specified expression.

FIRSTDATE DAX Function

Return the first date from the current filter context.

LASTDATE DAX Function

Return the last available date in the current filter context.

TIME DAX Function

Create a time value using hour, minute, and second parameters.

SECOND DAX Function

Extract the seconds component from a time value.

MINUTE DAX Function

Extract the minute component from a time value.

HOUR DAX Function

Return the hour component from a given time value.

DATEVALUE DAX Function

Convert a text string into a valid date value.

DATEDIFF DAX Function

Calculate the difference between two dates in specific intervals.

TIMEVALUE DAX Function

Convert a text string into a valid time value.

WEEKNUM DAX Function

Return the week number of a given date within the year.

CALENDARAUTO DAX Function

Automatically generate a calendar table based on model dates.

🔢 Mathematical Functions in DAX

SQRT DAX Function

Learn how to calculate square root values using the SQRT function in Power BI DAX.

ROUND DAX Function

Round numbers to a specified number of digits using the ROUND function.

MROUND DAX Function

Round numbers to the nearest multiple using the MROUND function.

ROUNDDOWN DAX Function

Round numbers down toward zero using the ROUNDDOWN function.

ROUNDUP DAX Function

Round numbers upward away from zero using the ROUNDUP function.

QUOTIENT DAX Function

Return the integer portion of a division operation.

FLOOR DAX Function

Round numbers down to the nearest specified multiple.

INT DAX Function

Return the integer part of a number by rounding down.

CEILING DAX Function

Round numbers upward to the nearest specified multiple.

TRUNC DAX Function

Truncate numbers by removing decimal values.

DIVIDE DAX Function

Perform division safely with alternate results for divide-by-zero errors.

EVEN DAX Function

Round numbers up to the nearest even integer.

ODD DAX Function

Round numbers up to the nearest odd integer.

MOD DAX Function

Return the remainder after division between two numbers.

📊 Table Functions in DAX

Table Constructor in DAX in Power BI

Learn how to create temporary tables directly inside DAX expressions.

TOPN DAX Function

Return the top N rows from a table based on sorting conditions.

UNION DAX Function

Combine rows from multiple tables into one result set.

EXCEPT DAX Function

Return rows from one table that are not present in another.

INTERSECT DAX Function

Return rows that exist in both tables.

DISTINCT DAX Function

Return unique values from a column or table.

COUNTROWS DAX Function

Count the number of rows in a table.

VALUES DAX Function

Return a table containing distinct column values.

GENERATESERIES DAX Function

Create a numeric series table with defined start and end values.

DATATABLE DAX Function

Create tables directly inside DAX formulas using defined values.

TOCSV DAX Function

Convert table data into CSV formatted text.

TREATAS DAX Function

Apply filters from one table to another table.

TOJSON DAX Function

Convert table expressions into JSON format.

SUMMARIZE DAX Function

Create grouped summary tables with aggregation.

ROW DAX Function

Create a table with a single row and defined columns.

🔗 Relationship Functions in DAX

RELATED DAX Function

Retrieve values from related tables using relationships.

RELATEDTABLE DAX Function

Return rows related to the current row in another table.

USERELATIONSHIP DAX Function

Activate inactive relationships inside calculations.

CROSSFILTER DAX Function

Modify filter direction between related tables.

ℹ️ Info Functions in DAX

INFO.MEASURES DAX Function

Return metadata information about measures in a model.

INFO.TABLES DAX Function

Retrieve metadata details for tables in the data model.

INFO.COLUMNS DAX Function

Return metadata details for columns in the model.

🌳 Parent-Child Functions in DAX

PATH DAX Function

Create hierarchical paths for parent-child relationships in Power BI.

PATHCONTAINS DAX Function

Check whether a value exists within a hierarchical path.

PATHITEM DAX Function

Extract specific elements from hierarchical paths.

PATHITEMREVERSE DAX Function

Return elements from hierarchical paths in reverse order.

PATHLENGTH DAX Function

Return the number of elements in a hierarchy path.

🧩 Miscellaneous DAX Functions

ISFILTERED DAX Function in Power BI

Learn how the ISFILTERED function detects whether a column is filtered in a report.

ISCROSSFILTERED DAX Function in Power BI

Understand how ISCROSSFILTERED detects filters applied through relationships.

SUMMARIZECOLUMNS DAX Function

Aggregate and group data efficiently using SUMMARIZECOLUMNS.

COUNT DAX Function

Count numeric values within a column using the COUNT function.

COUNTA DAX Function

Count all non-empty values in a column using COUNTA.

DISTINCTCOUNT DAX Function

Count unique values in a column using DISTINCTCOUNT.

HASONEVALUE DAX Function

Check whether a column contains exactly one distinct value in the current context.

SELECTEDVALUE DAX Function

Return the selected value when a single value exists in the filter context.

CONTAINS DAX Function

Check whether specific values exist in a table.

ISEVEN DAX Function

Determine whether a numeric value is even.

ISODD DAX Function

Check whether a number is odd using ISODD.

FORMAT DAX Function

Convert numeric or date values into formatted text.

ISINSCOPE DAX Function

Determine whether a column is currently visible in the evaluation scope.

DISTINCTCOUNTNOBLANK DAX Function

Count distinct values while ignoring blank values.

COUNTBLANK DAX Function

Count blank cells in a column using COUNTBLANK.

EARLIER DAX Function

Reference earlier row context when performing nested calculations.

RANDBETWEEN DAX Function

Generate random numbers within a specified range.

ISERROR DAX Function

Detect whether an expression returns an error.

CONTAINSROW DAX Function

Check whether a row with specific values exists in a table.

GROUPBY DAX Function

Group rows and perform aggregations in DAX queries.

FIXED DAX Function

Format numbers with a fixed decimal representation.

IFERROR DAX Function

Return an alternative value when an expression results in an error.