00196-2

DAX variables

When you write DAX expressions it is a general recommendation not to overestimate their complexity. It is always better to create several measures and further consolidate them within the new formula. The code is more transparent, and there is a lot less chance to make an error. Since recently DAX also allows making variables. They are used to create measures that will be used to create an expression that returns final result.

00198-3

Manual data entry

PowerBI Desktop allows you to obtain data from different sources. They are being acquired into tables between which we later create relationships to create the Data Model. Sometimes it is necessary to have temporary table that needs to be used to create a specific report. To create such a table and manually fill it, you can use the Enter Data option.

00195-2

Data transformation

After importing data there is often a need to rearrange or update them so that we get adequate inputs on the basis of which we can make reports. Previously, to perform that, we used traditional Excel functions, and a few years ago an Excel add-in called PowerQuery was released. It offers the possibility of obtaining data from a variety of sources and the possibility of transforming them. Good News: PowerQuery is integrated in PowerBI!

00190-6

Creating reporting dimensions

Reporting dimensions are all fields that you can see in the Fields menu, which are used to populate reports. Basically, these are the columns in the table model. Also, they can be Calculated Columns or Measures. In some earlier “recipes” I talked about how to create them in PowerPivot model, and now I will show you how to do perform this in PowerBI Desktop. Also, I will mention another interesting novelty: Calculated Tables!

00189-4

Custom visuals

PowerBI Desktop has a number of tools for data visualization- visuals. They allow the data that is imported into Model to be used for creation carts, tables, variety of charts, slicers … Sometimes there is a need for specific visualization tools that are not offered in the standard range. We call them Custom visuals. You can find them all in the Office Store, download desired visual, install it, add appropriate data set and bring data to life!