Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to compare data between two different data sets in Power BI?

Hi All,

First time poster so please bear with me

I have two data sets e,g (May file and June file)  which includes actuals and forecast figures which are updated on a monthly basis. 

 

I would like to compare the the two data sets in Power BI to be able to analyse it, for example show YOU and be able to visualise it.  Below is an example of the data set

 

Thanks for your help

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Ahh,

     

    I was a little slow to it, I completely understand what you mean and that should work. 

     

    Will do that now!!

    Thanks for your help

7 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

    You can use Merge Queries in Query editor, joining on all the fields but the once you need to compare.


    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski


     

  • Omega's avatar
    Omega
    Impactful Individual
    7 years ago

    Create a column left to date and call it Month of Load. In the column add the months you are trying to compare. Then, append both tables to generate one table :) 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      If I append the table, how am I able to seperate the different data sets since almost everything will almost be identical. I need to be able to compare the whole year's gross in the May data against the same in the June data against variables like in the case of say month or client.

      • Omega's avatar
        Omega
        Impactful Individual
        7 years ago

        That's why I mentioned to create a new column which will help you seperate both datasets :)

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks, 

       

       

      This has worked, how would I do  a YOY comparison on it?

      Omega wrote:

      Create a column left to date and call it Month of Load. In the column add the months you are trying to compare. Then, append both tables to generate one table :) 

       

      • Omega's avatar
        Omega
        Impactful Individual
        7 years ago

        You need to add a new column that contains the year and use sameperiodlastyear function to calculate your YoY :)