Forum Discussion
Solved
Sameperiod last year
Hi, I am new to Power Bi. I have uploaded a Spreadsheet with the following Columns Day - Month - Year - Revenue per day - Customer I have created a Slicer to switch between Customers a...
Hi Casey,
There was just a small error with the DAX formula and I was able to fix it.
Also if you want the difference to calculate for the whole year you will need a separate date table with the complete months for 2023. I added it and added a new "Total Diff Full Year" measure to calculate for all of 2023.
Let me know if you have any further questions.Link: Items Fixed.pbix
Did I answer your question? Mark my post as a solution!
AlanFredes
Resolver IV
Resolver IVHi Casey,
Can you send me an example file with your data?
I could replicate it there and send it back.
Upload the file to google docs or onedrive and send me the link.
Regards,
Alan
