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

[Anonymous]

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

 

[Mariusz]

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.

[Omega]

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]

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]

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

[Anonymous]

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]

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

[Anonymous · Accepted solution]

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