29 DAX Functions you must know

By | June 16, 2020

PowerBI has been the preferred BI tool for a large number of companies in recent times. As the tools get adopted we have seen a number of reporting scenarios from Basic excel porting to complex Machine Learning models. Regardless of how you plan to utilize PowerBI it is important to learn and understand the DAX formulas available in PowerBI.

In this series we aim to cover 30 DAX Formulas we encounter regularly when working on projects and feel these are common enough to be useful for interviews and projects alike.

Before we start the below set of link take you to the appropriate DAX formula, some DAX Formula need to be in conjunction with others. The example and screenshots used in this series are based on the WorldWideImporters database. Which can be downloaded and restored here.

We are using the May 2020 release of PowerBI so the screens may look slightly different but the Formula being used will be the same regardless of version.

You can use the below Index to navigate to the appropriate post.

ALL

CALCULATE

CALCULATETABLE

CALENDAR

CONCATENATE

CONTAINS

CONVERT

DATEDIFF

EXCEPT

FILTER

FIND

FORMAT

IF

ISBLANK

PARALLELPERIOD

PERCENTILE.EX

RANKX

ROUND

SAMEPERIODLATEYEAR

SUBSTITUTE

SUM & SUMX

SUMMARIZE

SWITCH

TOPN

TOTALYTD

TREATAS

USERELATIONSHIP

USERNAME

VAR