Category: Power BI from Rookie to Rockstar

Power BI DAX RelatedTable Function: Get the subtable related to the current row

Posted on by Reza Rad

There are multiple functions that can help when you work with tables that are connected through relationships. One of these functions is Relatedtable. This function gives you the subtable from the other table for all the rows related to the current row. For example, all sales transactions (from the Sales table) for the current customer Read more about Power BI DAX RelatedTable Function: Get the subtable related to the current row[…]

Row Filtering in Power BI and Power Query: Remove Blank Rows Vs. Remove Empty

Posted on by Reza Rad

When you have blank values in your data table, you can use Power Query transformations to remove the row with blank values. There are two transformations that are used very often for this purpose: Remove Empty and Remove blank rows. These two transformations are not exactly the same. In this article, I’ll explain what is Read more about Row Filtering in Power BI and Power Query: Remove Blank Rows Vs. Remove Empty[…]

Create a Table in Power BI using Enter Data, and How to Edit it

Posted on by Reza Rad

Sometimes you just need a new table with a few rows or columns to be added to your data model. One option to create that table is to use the Enter Data option in Power BI Desktop. In this article, I’ll explain how you can use it, and also; more important: How to edit the Read more about Create a Table in Power BI using Enter Data, and How to Edit it[…]

Export Power BI Audit log in a few Simple Steps with No Code

Posted on by Reza Rad

The Power BI related activity in your organization can be often useful. You can use the activity (audit) log to determine the behavior of the users and enhance the adoption of Power BI in your organization. To get the audit log, however, the process isn’t simplified yet. In this article and video I show you Read more about Export Power BI Audit log in a few Simple Steps with No Code[…]

Split Column by Delimiter in Power BI and Power Query

Posted on by Reza Rad

If you have a delimiter character (or part of the text) that is repeated multiple times, and you want to extract all the text parts based on that, there is a simple way for it. In this article, I’ll explain how to extract multiple parts of a text value based on a delimiter in Power Read more about Split Column by Delimiter in Power BI and Power Query[…]

Extract Parts of a Text Value in Power BI using a Delimiter: Power Query Transformation

Posted on by Reza Rad

If you have a text field and you want to extract a part of that text field, there are multiple ways to do that. You can do this using the SUBSTRING function in DAX. However, These types of actions are better to be done using Power Query transformations. Fortunately, Power Query is very easy and Read more about Extract Parts of a Text Value in Power BI using a Delimiter: Power Query Transformation[…]

Get a field value from a related table in Power BI: DAX RELATED Function Explained

Posted on by Reza Rad

Sometimes, in Power BI, you need to access a field’s value from another table that somehow is related to the existing table. You can use Power Query transformations such as combining Merge with something else. However, this can be needed when you write a DAX expression too. In this article and video, I explained a Read more about Get a field value from a related table in Power BI: DAX RELATED Function Explained[…]

Document the Power BI Tenant objects: Workspace, reports, datasets, dataflows with no code

Posted on by Reza Rad

Previously I explained how you can document a single Power BI file. Another very common documentation requirement is to find out what objects, workspaces exist in the Power BI tenant and document them all. even you may want to download all the PBIX files from the service and keep it for versioning purposes. In this Read more about Document the Power BI Tenant objects: Workspace, reports, datasets, dataflows with no code[…]

FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations

Posted on by Reza Rad

You can apply filtering to visualization elements. However, sometimes filtering has to be done on specific calculations. This can come in handy especially when you want to compare values of other items with specific items. In this article and video, I’ll explain how to use the FILTER function in DAX to apply a custom filter Read more about FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations[…]

How to Reduce the Size of Power BI file in a few Steps

Posted on by Reza Rad

One of the performance considerations of a Power BI file is to reduce the size of it as much as possible. This also helps with the speed of development, because smaller files loads faster and easier in the Power BI Desktop. One way to reduce the size significantly is to find which columns are consuming Read more about How to Reduce the Size of Power BI file in a few Steps[…]