Data Analysis Tutorials
In this article, we will show you how to solve the error “A table of multiple values was supplied where a single value was expected” in Power BI. We have created some example data to help explain why this error occurs when you are writing DAX functions and to demonstrate three ways you can resolve … Read more
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
ln this article we will show you how to check for blank values and nulls in Power BI. We cover how to use the ISBLANK DAX function, but also provide a second solution if you need it. IsNull in Power BI The IsNull function does not exist in Power BI DAX. Therefore it can’t be … 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