Power of Filters

Filters are important part of every Power Query project and should not be underestimated. Let’s have a look on how to easily build & optimize your filters. As usual, the difficulty will increase with every following example. ***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign […]

Recommended Power Query Settings

One should never underestimate settings in Power Query. So let’s have a look on few recommendations which can save you lots of pain in future. This articles covers only the most relevant settings (not all). Settings not covered in this articles are usually self-explanatory. ***Tip: Have a question? Ask in the comment section below or […]

Google Data Studio vs. Power BI

Google Data Studio has been public for a while. It has already changed PPC reporting routines of many people. But how does Google Data studio compare with Microsoft’s Power BI which has been on the market for few years? Read more to find out. ***Tip: Have a question? Ask in the comment section below or […]

IF Function in Power Query for Advanced

In the previous article, we looked at IF function basics. Today, it is time to look at more advanced stuff. Spoiler alert: nested formulas (aka “vnořené funkce”) included. ***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** ***Do you feel like […]