Lot of real-life scenarios require some sort of text analysis. Unfortunately, the majority of those analysis is done in other tools than Power BI.

In this article I would like to show how to search for a specific text substring (or multiple of substrings) and dynamically filter my query based on those search results.

Join us for Power BI Dev Camp to learn everything you ever wanted to know about setting datasource credentials for Power BI datasets with code.

Rounding in Excel and Power Query can lead to costly mistakes if not applied consistently. In this blog post, I compare their default rounding functions and demonstrate how they can produce different results. I provide a solution to ensure consistency by using a third argument in the Round function in Power Query. Paying attention to the rounding function can avoid errors and ensure accurate financial analysis.