Data Analysis Tutorials
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
In this article, we show you how to check for numbers in Power Query and Power BI, as well as how to use the IsNumber DAX function. Power Query does not have an IsNumber function, but we have a way to mimic it. Power BI does have an IsNumber function, but it is not always … Read more
In this article, we will show you how you can check for dates in Power Query and Power BI. You may be used to using functions such as IsDate to check for dates in other languages, however Power Query and BI don’t have an IsDate function. Nevertheless, it is still possible to check for date … 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
In this tutorial, we show you how to round time and datetime values to the nearest 1, 15, 30 and 60 minutes in Power Query and Power BI. Rounding time in Power Query To round times or datetimes in Power Query, one simple formula is used. This can either be in a custom column, or … Read more