Forum Discussion
How to compare data between two different data sets in Power BI?
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
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 :)
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.
That's why I mentioned to create a new column which will help you seperate both datasets :)
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