Krešimir Ledinski

How to process multiple folders with a single PowerQuery script

Let us imagine the following scenario. We have multiple clients sharing their sales data with us. They store the data in dedicated folders that reside in different places. The number of clients, as well as the number of files for each client, will vary across periods. We wish to create an automatic refresh system that …

How to process multiple folders with a single PowerQuery script 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 a working example in embedded …

Sorting in Matrix created with calculation groups (PowerBI) Read More »

Conditional 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. Link to the second part of …

Conditional formatting with Calculation Groups in PowerBI Matrix visual 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 in object programming. The idea …

List.Generate() and Looping in PowerQuery 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 random spaces and non-printable characters …

Using M to dynamically change column names in PowerQuery Read More »

Scroll to Top