Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
94
Views
Topic starter
Hi,
I have faced a problem. My problem is how to add the Date Column by using the power query in excel? Here I have attached my sample excel file. I would like to add a date column before the Region column in my sample excel file by using a power query. And the date started from 01/01/2019 to 12/02/2019. Is it possible to add a date column by using the power query?
Thank you.
Regards,
M
Posted : 28/04/2021 2:40 am
Hi M,
Welcome to our forum!
You can use a Power Query list to generate a list of dates in a new query. Index both the dates and your data by region and then merge the queries using the Index column as the common denominator.
See example attached.
Mynda
Posted : 28/04/2021 7:35 am
Topic starter
Hi Mynda,
Thank you for your reply with the example. It's very helpful and valuable.
Regards,
Mazharul
Posted : 28/04/2021 8:16 am
