Power query

[Anonymous]

Hi everyone,

I'm working on a query that is a combination of 30 files that has in the top a particular date. So i need to report in a column all the dates for the lines of each file in the same query. Is there any suugestion on how to do that.

Thanks for your help;

[v-yingjl · Accepted solution]

Hi @Anonymous ,

If the dates in the files are both in the same column on a row,like this, there must be other blank values in other columns when you combine files in Power Query:

You can try like this query:

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattAllington]

Watch my presentation to the UK PBI User Group yesterday. I show how to do this. 

https://youtu.be/bhh5CxykEsA