Replace Values in Power Query – 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 …
Read more2 Awesome Tips on How to Use the SWITCH Function in Excel
3 Ways to SUM null values in Power Query
Getting unexpected results when summing up null values in Power Query is something beginners bump into all the time. And the reason for this is …
