How to use Power BI DAX – Tutorial

In this step-by-step tutorial for beginners, learn how to use DAX (Data Analysis Expressions) in Microsoft Power BI. DAX is a formula language with functions. If you’ve ever written formulas in Excel, you’ll find that DAX is very familiar.

We’ll start by loading the sample data into a data model. Next, we establish relationships between the various tables.

Once the setup is complete, we’ll write our first measure. A measure is a calculation that runs across our data model. You’ll learn about a few different functions, including sum and count. You’ll also learn how to comment your expressions.

Next, we create a measure using operators, like addition, subtraction, division, and multiplication. We then dive into how you can create measures using a graphical user interface called Quick Measures.

We then move onto creating a calculated column and talk about the advantages and disadvantages of columns vs. measures.

We then dig into iterator functions and when you would use them compared to an aggregator function. Iterator functions include sumx, countx, averagex, maxx, minx, and rankx.

Next, we look at the date functions that are available and we use the one called weekday. We wrap up by looking at some logical functions, including find, if, and calculate.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s