Forum Discussion

Justiy's avatar
Justiy
Regular Visitor
4 years ago
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...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    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/

tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

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/