Adriatic BI company specialized in
PowerBI / PowerApps / Excel
20+ international and domestic clients
Implementation and Education!
In this article, we will take a look at what is Power Apps, why should we use it, and when organizations can benefit from custom apps created in the Power Apps platform.Many organizations are not yet familiarized with Power Apps capabilities, and the ways it can improve their agility, modernize...Read more
In this blog, we will see how to merge two tables in Power Query based on key column and a date range. Merging with multiple matching columns is straightforward and can be achieved in Power Query by selecting merge queries option and holding CTRL key when choosing matching columns like...Read more
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 more
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 more
Microsoft certificate for being experts in BI reporting.
With modern Microsoft tools for data manipulation and analysis (PowerQuery, DAX).
of experience working with the PowerBI environment.