Text Functions in Power Query M (150+ Examples)
Text functions are foundational in your Power Query journey. They allow you to analyze and manipulate text values. And once you master them you will …
Text functions are foundational in your Power Query journey. They allow you to analyze and manipulate text values. And once you master them you will …
A leading zero is any 0 you add before the first nonzero digit of a string. By definition, these are invisible when a value has …
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 …
Most users know the Group By functionality in Power Query. It allows you to summarize data and aggregate the grouped values. The standard aggregations are …
A common operation in Power BI is calculating the Distinct Count of a column. You may, for example, want to show the number of unique …
In previous post you learned how to combine AND and OR criteria for SUMPRODUCT. The approach results in a long and difficult to maintain formula. …
In an earlier post I wrote about the advantages of using the Data Model in Power Pivot. Not only does it save you time by …
Introduction As Power Query beginner, it is comfortable to use the user-interface to change your column names. It’s easy and quick. You double click a …
There are situations where several criteria are required to add up the right numbers. That’s straightforward if the numbers are found in a single column …
SUMPRODUCT is a multi-purpose formula. In essence, it multiplies arrays and returns the sum of those products. It is different from most Array formulas in …