Adding Missing Dates To A .CSV File Via Power Query?..

Hi Guys!

I have imported a .CSV file with all the data i need.

The Headers after importing into Power Query are;

DATE / COURSE / TIME / NAME / RESULT

Problem i have is that i am trying to run a weekly test on these Values. I Filter the data i need for the week but i just realised that some days are missing as no Data
was recorded for that day.

How do i Add the missing dates? It Needs to show the missing date but the other headers can all be blank or just have "N/A" as values.

Any ideas if this can be achieved in Excel / Power Query?.. Or should i be looking at a .CSV Editor to add these missing dates?


Thanks for looking guys, appreciate it!

Hi Ourkid,

I think the easiest way to do what you are asking is create 'date' table and import that via PQ, then append the queries together. There are ways to do it without the extra table - but without the data it would be hard to explain.

Regards,

James

Thanks Guys!

Its to actually add them but thank you 'avk' im sure that code will come in useful, i'm actually testing that now.

Yes James that's what i have done. I have created a fully .CSV file with ALL the date and im playing around with trying to merge them together.
I cant understand the order or option though to add the extra dates to my main table?

Any ideas?

Brilliant!

Thank guys for your help and support... this has worked and i have taken all your variations and learnt alot!