Skip to content
Home » Power BI DAX Functions

Power BI DAX Functions




DAX (Data Analysis Expressions) is a powerful formula language used in Power BI, Excel, and Analysis Services. It allows users to create custom calculations and aggregations on data models, enabling deeper data analysis and more dynamic reporting. DAX functions include mathematical, logical, time intelligence, and text operations, making it essential for creating calculated columns, measures, and tables.

With DAX, users can transform raw data into meaningful insights through advanced expressions and powerful data manipulation.

Top 50 Power BI DAX Interview Questions and Answers

Top 50 Power BI DAX Interview Questions and Answers

Filter DAX Functions

ALL

ALLSELECTED

ALLEXCEPT

CALCULATE

CALCULATETABLE

FILTER

LOOKUPVALUE

OFFSET

RUNNINGSUM

Table Manipulation DAX Functions

ADDCOLUMNS

SUMMARIZE

ADDMISSINGITEMS

GROUPBY

DATATABLE

UNION

EXCEPT

INTERSECT

NATURALINNERJOIN and NATURALOUTERJOIN

ROW

SELECTCOLUMNS

Logical DAX Functions

IFERROR

SWITCH

IF

AND(&&)

OR(||)

NOT

COALESCE

Text DAX Functions

UPPER

LOWER

LEFT

RIGHT

CONCATENATE

CONCATENATEX

LEN

SUBSTITUTE

MID

FIND

SEARCH

REPT

EXACT

Information Functions

USERPRINCIPALNAME()

ISAFTER

ISONORAFTER

ISINSCOPE

Statistical DAX Functions

SAMPLE

RANKX

MEDIAN

Relationship Functions

USERELATIONSHIP

RELATEDTABLE

RELATED

Aggregations DAX Functions

COUNTROWS

DISTINCTCOUNT

COUNTBLANK

COUNT, COUNTA & COUNTX

MIN, MINA & MINX

MAX, MAXA & MAXX

AVERAGE, AVERAGEA, AVERAGEX

SUM Vs SUMX 

DISTINCTCOUNTNOBLANK 

Time Intelligence DAX Functions

Master All Time Intelligence DAX Functions in Just 90 Minutes! 🎥

OPENING BALANCE DAX & CLOSING BALANCE DAX 🎥

    1. OPENINGBALANCEMONTH
    2. OPENINGBALANCEQUARTER
    3. OPENINGBALANCEYEAR
    4. CLOSINGBALANCEMONTH
    5. CLOSINGBALANCEQUARTER
    6. CLOSINGBALANCEYEAR

FIRSTNONBLANK

LASTNONBLANK

PREVIOUSDAY

PREVIOUSMONTH

PREVIOUSQUARTER

PREVIOUSYEAR

TOTALMTD

TOTALQTD

TOTALYTD

SAMEPERIODLASTYEAR

PARALLELPERIOD

NEXTDAY

NEXTMONTH

Parent and Child Functions

PATH

PATHCONTAINS

PATHLENGTH

PATHITEM

Date & Time DAX Functions

DATE & TIME DAX Functions

    1. CALENDAR
    2. CALENDARAUTO
    3. DATE
    4. DATEDIFF
    5. DATEVALUE
    6. DAY
    7. YEAR
    8. MONTH
    9. QUARTER
    10. HOUR
    11. MINUTE
    12. SECOND
    13. EDATE
    14. EOMONTH
    15. TIME
    16. TIMEVALUE
    17. NOW
    18. TODAY
    19. WEEKDAY
    20. WEEKNUM
    21. YEARFRAC

Exploring DateTime Functions in DAX: Syntax, Examples, and Common Queries

Some other Important DAX topics

How to Identify New vs. Returning Customers based on their Transactions history in Power BI

SWITCH vs IF in DAX: Key Differences Explained

Best DAX Practices in Power BI

How to Dynamically Extract Text Before a Specific Character in Power BI using DAX

Dynamically Change Bar or Column Chart Colors in Power BI Using DAX

How to Calculate Year over Year(YOY) Growth % in Power BI?

Quick Measure Suggestions

Check Table 1 Value exist or not in Table 2 when there is no relationship between both tables

Create a calendar table in power bi to using DAX functions

Power BI Change display unit based on values in table visual

Cumulative Total/ Running Total in Power BI

Set functions in DAX – UNION, INTERSECT & EXCEPT

How to add line breaks in a string of text in DAX measure

LOOKUPVALUE DAX with Parent-child hierarchy functions

Displaying a Text message when no data exist in Power BI visual

DAX shortcut keys in Power BI Desktop

Display Top 2 products for each region in Power BI

Loading