Power of Filters

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** 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 […]

IF Function in Power Query for Advanced

***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** 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. For all the samples, […]