Forum Discussion
Solved
same report - how to the change source file ?
Hello, I have couple of excel files which I use as a datasoruces for my pbi report, which I built for a specific excel file. I want to add some kind of a filter, in which I can choose which datasou...
Hi Justiy ,
I would have suggested exactly that: Merge or rather union the files into one with an additional column describing the Month. After you can use that month column as a slicer. You could do something similar in DAX as well, but Power Query is to prefer in that scenario. Out of curiosity, why do you not want to union them into one file? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hello tackytechtom and thanks for your replay,
My excel files containes a lot of data and analysis, and not all the tables are equales.
So I think that megring will be hard to do.
Is there any other ways?