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.

One thought on “How to use Power BI DAX – Tutorial

  1. Sir, i require a full fledged course on DAX in powerbi….please help on it……..if you want any fees to be paid for your videos, then i will pay it…..i have bought my own licence of BI to learn…please share..


Leave a Reply

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

You are commenting using your 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