Forum Discussion
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 li...
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
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 :)
You need to add a new column that contains the year and use sameperiodlastyear function to calculate your YoY :)