Adriatic BI company specialized in
PowerBI / PowerApps / Excel
20+ international and domestic clients
Implementation and Education!
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...
Read moreDynamically expand table or record columns in Power Query
In this article, we will show how to solve a common problem of expanding nested tables or records in Power Query, when the column names of the nested objects vary in numbers. In the second part of the article, we will show a more robust technique for dealing with changing...
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 more
WE HOLD
Microsoft certificate for being experts in BI reporting.

8+ YEARS
With modern Microsoft tools for data manipulation and analysis (PowerQuery, DAX).

4+ YEARS
of experience working with the PowerBI environment.
MORE THAN 20
Satisfied domestic and international clients.
Learn With Exceed Academy
Improve your skills in our Exceed Academy, tailored for both beginners and professional.
