When applying text transformations in Power BI using Power Query; two very important transformations that can help are; Trim and Clean. These two mistakenly often considered to do one thing, but they are different. In this short article and video, I’ll explain their differences through an example. Video Sample text Let’s assume I have a Read more about Trim Vs. Clean in Power BI and Power Query[…]
There are many useful transformations in Power Query for Power BI. One of them is adding the prefix and suffix to a text column. These transformations are very simple to apply and have an immense value in building columns based on patterns and template texts. In this short video and article, I’ll explain how you Read more about Add Prefix and Suffix to a Text in Power BI: Generate Country Images and pages[…]
Power BI has the built-in feature of creating binning for a numeric field such as age. However, the default binning will create bins of equal size. If you want to create bins of different sizes, then you need to create that as a custom column. Fortunately, Power Query has transformations that can help. In this Read more about Create Customized Age Bins (or Groups) in Power BI[…]
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[…]
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[…]
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[…]
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[…]
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[…]
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[…]
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[…]