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 …
Comparer.OrdinalIgnoreCase
Lists in Power Query M / List Functions (200+ Examples)
Lists in Power Query are often used for data transformations. You commonly find lists of numbers, letters, times, dates etc. And these lists are useful …
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 …
