Adriatic BI company specialized in
PowerBI / PowerApps / Excel

20+ international and domestic clients
Implementation and Education!

Pre-holiday for PowerQuery Fundamentals course and Online consulting!

Days
Hours
Minutes
Seconds

PowerQuery Fundamentals Course

30% off the regular price!

Online Consulting
Hours

50% off the regular price!

Split 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 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

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.

Scroll to Top