Blog
We write articles and blogs on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post topic.
Sorting in Matrix created with calculation groups (PowerBI)
This is the second part of the blog series dedicated to showing workarounds for currently unsupported matrix visual features. In the first part we explained how to add conditional formatting only for the specified columns, and in this article, we will explain how to introduce sorting. Below, you can test...
Read MoreConditional formatting with Calculation Groups in PowerBI Matrix visual
This is going to be the first of 2 articles explaining how to introduce conditional formatting and sorting when using calculation groups in Matrix visual. It would be great if conditional formatting and sorting could be applied to a calculation item, but until this happens, here is a workaround. Below,...
Read MoreHow to track changes in the table in Power Query
In this article, we will show you the way to track changes you make in your table by using Power Query. The presumption is that we have one table that serves as a database (HistoryData). Then we have a new table which has the same structure as the first one,...
Read MoreSplit packs into single products in Power Query
Sometimes in the Fact table, we can have packs with multiple products included. In this blog, we will show how to split those packs into individual products and how to assign correct sales values and quantities to each individual product within the pack. The problem The Fact table contains multiple...
Read MoreNested functions and Table.Buffer()
In this blog, we will explain nested functions in Power Query, as well as how to optimize these functions with buffering. By using nested functions and buffering, we will combine most of the advanced M coding. Business case We will demonstrate the business problem we want to solve with the...
Read MoreDynamically remove top rows in Power Query
Removing top rows is straightforward from within the Power Query user interface and if done only upon one source. The problem arises when we need to remove a dynamic number of top rows from multiple sources and we don’t know the exact number of redundant rows in each source. In...
Read MoreSorting in Matrix created with calculation groups (PowerBI)
This is the second part of the blog series dedicated to showing workarounds for currently unsupported matrix visual features. In the first part we explained how to add conditional formatting only for the specified columns, and in this article, we will explain how to introduce sorting. Below, you can test...
Read MoreConditional formatting with Calculation Groups in PowerBI Matrix visual
This is going to be the first of 2 articles explaining how to introduce conditional formatting and sorting when using calculation groups in Matrix visual. It would be great if conditional formatting and sorting could be applied to a calculation item, but until this happens, here is a workaround. Below,...
Read MoreIncremental refresh using PowerBI pro and Dataflows
In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI Pro version. This technique is tested and working both with cloud and on-premises data sources. In case you are using on-premise data sources to access new data, you need to add on-premise source...
Read MorePivottables inside the PowerBI – the DAX way
In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI Pro version. This technique is tested and working both with cloud and on-premises data sources. In case you are using on-premise data sources to access new data, you need to...
Read MoreHow to split budgets to lower granularity with DAX (PowerBI)
When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis. But sometimes we are required to match budgets to actual sales on lower granularities than the one we previously set (e.q. the manager wishes to...
Read MoreOptimizing distinctcount with reduced memory consumption in PowerBI (VertiPaq)
High cardinality columns are often the problematic part of the data modeling in most environments, including PowerBI. Since the PowerBI data model resides on a columnar database, having high cardinality columns impact both performance and the size of the model. This is especially the case with columns having more than...
Read MoreSorting in Matrix created with calculation groups (PowerBI)
This is the second part of the blog series dedicated to showing workarounds for currently unsupported matrix visual features. In the first part we explained how to add conditional formatting only for the specified columns, and in this article, we will explain how to introduce sorting. Below, you can test...
Read MoreConditional formatting with Calculation Groups in PowerBI Matrix visual
This is going to be the first of 2 articles explaining how to introduce conditional formatting and sorting when using calculation groups in Matrix visual. It would be great if conditional formatting and sorting could be applied to a calculation item, but until this happens, here is a workaround. Below,...
Read MorePivottables inside the PowerBI – the DAX way
In this article, we will see how we can use the self-referencing technique and Dataflows to create incremental refresh with PowerBI Pro version. This technique is tested and working both with cloud and on-premises data sources. In case you are using on-premise data sources to access new data, you need to...
Read MoreHow to split budgets to lower granularity with DAX (PowerBI)
When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis. But sometimes we are required to match budgets to actual sales on lower granularities than the one we previously set (e.q. the manager wishes to...
Read MoreOptimizing distinctcount with reduced memory consumption in PowerBI (VertiPaq)
High cardinality columns are often the problematic part of the data modeling in most environments, including PowerBI. Since the PowerBI data model resides on a columnar database, having high cardinality columns impact both performance and the size of the model. This is especially the case with columns having more than...
Read MorePowerBI One Measure for Multiple Dimensions/Facts – DAX
In this article, we will see how to combine different dimensions and facts inside a single matrix table visual. This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there...
Read MoreHow to track changes in the table in Power Query
In this article, we will show you the way to track changes you make in your table by using Power Query. The presumption is that we have one table that serves as a database (HistoryData). Then we have a new table which has the same structure as the first one,...
Read MoreSplit packs into single products in Power Query
Sometimes in the Fact table, we can have packs with multiple products included. In this blog, we will show how to split those packs into individual products and how to assign correct sales values and quantities to each individual product within the pack. The problem The Fact table contains multiple...
Read MoreNested functions and Table.Buffer()
In this blog, we will explain nested functions in Power Query, as well as how to optimize these functions with buffering. By using nested functions and buffering, we will combine most of the advanced M coding. Business case We will demonstrate the business problem we want to solve with the...
Read MoreDynamically remove top rows in Power Query
Removing top rows is straightforward from within the Power Query user interface and if done only upon one source. The problem arises when we need to remove a dynamic number of top rows from multiple sources and we don’t know the exact number of redundant rows in each source. In...
Read MoreList.Generate() and Looping in PowerQuery
In this blog, we will explain an advanced topic about the M language – using List.Generate to loop over a table. We will combine our knowledge of lists, records, functions, iterations, and looping techniques. Basically, every important object in PowerQuery. Do-while Loop in PowerQuery Do while loop is commonly used...
Read MoreUsing M to dynamically change column names in PowerQuery
In this article, we are going to talk about cleaning and transforming column names dynamically and in a bulk. The article was inspired by a request from a client who had issues exporting data from its data warehousing program to .csv files. Out of an unknown reason, program was adding...
Read MoreAUTHORS
Krešimir Ledinski
Microsoft certified expert in the field of Business Intelligence. His biggest passions are DAX, M, and data modeling.
Kristian Radoš
Experienced data analyst. Advanced in SQL, PowerApps and M language.
