Forum Discussion
Comparing data sets
Hi there I have been trying to compare two data sets (for example between the month of November and December) in Power BI. I have included Dropbox links below to basic data that I am trying t...
lbendlin
Super User
Super UserI can provide a sample pbix but you will have to adjust the Source part and point it to the folder where you have the files.
Hi lbendlin
Many thanks for your help, that seemed to work.
I was just wondering do you know if instead of using the method you suggested where you point to a particular Source location for the 2 files, is it possible to add both the Risk data Nov 2023 and Risk data Dec 2023 as 2 seperate Queries into Power Query and then use the Merge Queries option on their Residual Risk Rating? If you can let me know the steps if you take that approach that would be appreciated.
Many thanks
- lbendlin
Having separate sources is not a sustainable approach, I would recommend against doing that.