Power Query

In this article, we will show you everything you need to know about splitting columns by delimiters in Power Query. We cover how to split a column or multiple columns by delimiter into rows or columns, how to split by multiple different delimiters types, and special delimiters such as carriage returns and line breaks. How … Read more

In this article, we will show you how to add an index column in Power Query, what they can be used for, as well as how to create an index column by group (based on another column). How do I add an index column in Power Query? To add an index column to your table … Read more

In this article, we will explain how to use the Text.Length function in Power Query. It can be used in combination with other functions to improve data quality and find the values you are looking for. We will cover how to use Text.Length in a filter, how to use greater/less than in Text.Length formulas and … Read more

Clean text (Text.Clean function) in Power Query removes control and non-printable characters. This is useful for cleaning text data. For example, if your source data has had things like line breaks added, using text.clean will allow you to remove these in one step. Cleaning text in Power Query is different from other text functions such … Read more

In this article, we will cover how to trim text in Power Query. We go into detail on how to trim different types of text, such as whitespace, leading and trailing zeros as well as first and last characters. This is done by using Text.Trim functions and variations of it. This is very useful for … Read more

In this article, we show you how you can check and test for null values in Power Query. This can be useful if you want to create a custom column and return a certain value if a cell is null, rather than replacing null values. We cover how you can easily mimic IsBlank and IsNull … Read more

In this article we will show you how to calculate the difference between dates and times in Power Query. We include how to count the number of days, months and hours between two dates or from today, as well as the number of hours between two times. If you want to know how to calculate … Read more