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 …
Errors
Errors in Power Query signal that an expression can not produce a result. Errors can appear when working with operators or when working with error expressions. You can create an error record but also work with them using the try..otherwise construct.
Fix XLSB File Errors in Power Query
A XLSB File error can come to you by surprise. Recently one of my clients built a Power Query solution. In one of the steps, …