Blog

Redovito pišemo članke i blogove o tehnologijama Microsoft Business Intelligence. Popis u nastavku prikazuje sav naš sadržaj sortiran kronološki - možete filtrirati sadržaj prema temi posta.

  • ALL
  • POWERBI
  • DAX
  • POWER QUERY

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 More

How to track changes in the table in Power Query

If you ever had a need to check if anything changed in the new table compared to the previous export, no matter in which column, then this is the article for you. We have created an M script in Excel that uses the left anti join to check for data...

Read More

Split packs into single products in Power Query

This is going to be an easy to follow article on how to use PowerQuery to easily change source data granularity for only a subset of data. We used a client’s request to split packs into its components as an inspiration to write this post. You can also download Excel...

Read More

Nested 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 More

Dynamically 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 More

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 More

Pivottables inside the PowerBI – The DAX way

PivotTables, or pivoting, is by far the best analytical power of Excel. You digest the data and play with it on the fly. Heck, PowerBI is pretty much PivotTables with pretty visuals, just a lot smarter (because of DAX). While PowerBI offers many stunning looking visuals including matrices, they do...

Read More

How 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 More

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 More

Pivottables inside the PowerBI – The DAX way

PivotTables, or pivoting, is by far the best analytical power of Excel. You digest the data and play with it on the fly. Heck, PowerBI is pretty much PivotTables with pretty visuals, just a lot smarter (because of DAX). While PowerBI offers many stunning looking visuals including matrices, they do...

Read More

How 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 More

PowerBI 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 More

How to track changes in the table in Power Query

If you ever had a need to check if anything changed in the new table compared to the previous export, no matter in which column, then this is the article for you. We have created an M script in Excel that uses the left anti join to check for data...

Read More

Split packs into single products in Power Query

This is going to be an easy to follow article on how to use PowerQuery to easily change source data granularity for only a subset of data. We used a client’s request to split packs into its components as an inspiration to write this post. You can also download Excel...

Read More

Nested 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 More

Dynamically 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 More

List.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 More

Using 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 More

Autori

Krešimir Ledinski

Krešimir Ledinski

Microsoftov certificirani stručnjak u području poslovne inteligencije. Najveće su mu strasti DAX, M i modeliranje podataka.

Kristian Radoš

Kristian Radoš

Iskusni analitičar podataka. Napredan u SQL, PowerApps i M jeziku.

SUBSCRIBE TO NEWSLETTER

Receive latest updates on all business analyst news across all platforms.
Scroll to Top