Archive Post Page
Evaluate and transform column data types – Prepare the data
Evaluate and transform column data types If the data source does not communicate the type…
Using locale – Prepare the data
Using locale Occasionally, you will need to transform data by using a certain locale. For…
Working with query steps – Prepare the data
Working with query steps To start getting the Targets for 2022 query in the right…
Reducing rows and columns – Prepare the data
Reducing rows and columns Since the first three rows don’t contain any meaningful data, we…
Pivoting columns, unpivoting columns, and transposing – Prepare the data
Pivoting columns, unpivoting columns, and transposing The current Targets for 2022 query is sometimes called…
Adding columns – Prepare the data
Adding columns You can add a new column in Power Query by using one of…
Targets – Prepare the data
Targets In the Targets query, you have yearly targets, and you need to have monthly…
Combine queries – Prepare the data
Combine queries There are two main ways to combine queries in Power Query: Append This…
Merge – Prepare the data
Merge As discussed earlier, when you merge queries you combine them horizontally; as a result,…
