Forum Discussion

em101's avatar
em101
Frequent Visitor
2 years ago

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...
Need Help
em101's avatar
em101
Frequent Visitor
2 years ago

Hi lbendlin 

Thanks for your reply, but I'm new to PowerBI and a bit confused still. 

If you can explain the steps in a bit more plain English that would be great, eg you first load the two files into Power Query, then Filter Rows by doing XYZ... 

If possible, can you provide a sample Power BI file showing the implemented steps you documented above? 

 

Many thanks 

em101 

 

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

I 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.

 

 

 

 

  • em101's avatar
    em101
    Frequent Visitor
    2 years ago

    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's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Having separate sources is not a sustainable approach, I would recommend against doing that.