Forum Discussion
Two year data comparison - please help
Hi, I have data in one single spreadsheet for the year 2017 and 2018 (Adding 2019 later). I want a line or Bar chart which compares two years of commission data in one visualization. However,...
Take a look at this post as it talks about how to set this all up:
But one thing that isnt in that post, is the formula for Total Sales of the last period :
Total Sales Last Period = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR( DimCalendar[Date] ))
Hi
Thank you for your reply.
I have found a different solution. i willl share if anyone needed.