Power Query: See it, Save it, Sort it - Part 3
1 June 2022
Welcome to our Power Query blog. This week, I append queries to extend my data.
In Power Query: See it, Save it, Sort it – Part 1, I started with some data for my imaginary salespeople:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-1.png/8dc11f3f19b7a2701f41583d95fd1ed1.jpg)
and extracted it into Power Query, in order to perform some transformations:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-2.png/2a3af7f800bcc71c0f8ffdb826bfff6a.jpg)
Last week, I looked at the earliest and latest values of Date, and I created a query that would have a row for every consecutive day between those values. I called that query Full_Dates.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-4.png/038ea1b862e44ca168bd0cac4bedabe2.jpg)
Now, I want to append Full_Dates to Sales_Transactions, so that I will have a row on Sales_Transactions for every consecutive date.
I start in the Sales_Transactions query and choose ‘Append Queries’ from the ‘Append Queries’ dropdown on the Home tab.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-4.png/038ea1b862e44ca168bd0cac4bedabe2.jpg)
In the dialog, I use the basic ‘Two tables’ option and choose Full_Dates.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-5.png/88472a98bf6cec2c7a8d567b9676cd79.jpg)
This extends the Sales_Transactions table:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-6.png/546c0044682c277b6e2de1ec0eaac993.jpg)
Note that the Date column is now type ‘Any’. This is because I have appended a column with data type ‘Date’ to a column with data type ‘Date/Time’.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-7.png/d091aa729dd83bd5704c9375eb32461b.jpg)
I could rectify this by using the dropdown from the data type icon to change the data type of Date to ‘Date’.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-8.png/437781a6096e7ead6cb5f88081e5591b.jpg)
However, I can solve this a different way. I change the data type of the column before the ‘Appended Query’ step:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-9.png/21769613d2e2df1abe9941d5f7e9ce32.jpg)
Power Query checks that I want to insert a step:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-10.png/de9fb3ecfd6c2d20d16371aa04283efa.jpg)
I continue, and I am prompted to amend the existing ‘Changed Type’ step.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-11.png/65c1c6cf37d49c98980d81fa1f3e42f2.jpg)
I choose to ‘Replace current’ and the step is amended:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-12.png/5e888f5a24bfdcc5c8cbbbaaf4ade79f.jpg)
This means that the data type on Date of Sales_Transactions matches the Date on Full_Dates for the ‘Appended Query’ step:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2022/power-query/287/power-query-13.png/5e18cd84fb62af7fdd6414e95966e219.jpg)
This saves me adding a new step to change the data type of Date.
Next time, I will organise the data in Sales_Transactions.
Come back next time for more ways to use Power Query!