Replace Values in Power Query M (Ultimate Guide)
Replacing values is a common transformation for cleaning data. Power Query allows you to easily replace values using the user interface. Yet, this is often …
conditional if-statement
The IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)
The IF function in Power Query is one of the most popular functions. It allows you to make comparisons between a value and what you’re …
2 Awesome Tips on How to Use the SWITCH Function in Excel
The SWITCH Function is one of Excel’s logical functions that can function as an alternative to the conditional if-statements. Many excel users use if-statements to …
3 Ways to SUM null values in Power Query M
Trying to sum columns with null values in Power Query but getting unexpected results? It is something beginners bump into all the time. And the …
