April 27, 2021
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?
July 16, 2010
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.