Solved: Power query

Anonymous · ‎03-04-2022

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 · ‎03-07-2022

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.

View solution in original post

v-yingjl · ‎03-07-2022

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 · ‎03-04-2022

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

https://youtu.be/bhh5CxykEsA

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.