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
Mastering IF Statements in Power Query – Including Nested IF-Statements
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 …
