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. This article will NOT tell you which tool is better or the […]
Month: July 2017
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 included. For all the samples, we will be using the following image as basis: A sample Excel file with applied IF functions can be downloaded here: Text Editor Is Better than […]
IF Function in Power Query for Beginners
The best function of all times. IF function. Everyone has heard about it but only few can use it. So how does IF function work in Power Query? Well, there is a button for that. As usual. You will be able to complete basic IF conditions purely with the “IF function help wizard”. For the […]