Data Analysis Tutorials
We will show you how to check to see if a value exists in another column in Power Query. If you want to check if a value exists in another column in the same table, there are two methods we have to share. If you want to find values in columns in two different tables, … Read more
We will show you how to find and replace values greater or less than specified values in Power Query. You can do this easily using either the Table.ReplaceValue function or Table.TransformColumns function and combine one of these with an if statement and the <>= operators. Here is an example of a table with numbers between … Read more
This article will show you how to find and replace values based on another column in Power Query. Here is an example table with references in the first column and types of animals in the second column. To demonstrate how to find and replace values based on other columns, we will use the ‘Reference’ table … Read more
This article will show you how to find and replace values in Power Query that start with a certain value of your choice. Here is an example table with references that should all begin with ‘A0’. However, some values are missing the ‘A’. Therefore we want to find and replace all values that begin with … Read more
Do you have null values in your Power Query table that you want to find and replace with more useful data? In this article we go through how to: These methods will show you how to find and replace nulls without having to add a custom column, which can add unnecessary complications to your data. … Read more
In this article, we will show you how to replace values in multiple columns in Power Query using two different methods. Method 1 is best if you want to replace one value in multiple columns. Method 2 is best if you want to replace multiple values in multiple columns. Method 1: Select multiple columns and … Read more
In this article we will show you two methods for finding and replacing multiple values in Power Query, depending on your data and circumstances. The first method we share can find and replace values in one step using an IF statement. The second method uses a separate query and a custom column with List.Accumulate to … Read more