Forum Discussion
SamePeriodLastYear
I have been using the samperiodlast year function to calucation prior year revenues and counts of jobs and quotes. For some reason it has stopped working for me. If I use this calculation then the n...
littlemojopuppy
Community Champion
Community ChampionCheck your calendar/date table to make sure it includes 2020 dates.
Second thing...your formulas seem like they could take advantage of time intelligence. For example:
Current Year Estimated Revenue =
TOTALYTD(
[Total Estimated Revenue]
Calendar(Date)
)
Prior Year Estimated Revenue =
TOTALYTD(
[Total Estimated Revenue]
SAMEPERIODLASTYEAR(Calendar(Date))
)I don't know the name of your date table so I'm improvising. But try checking those two things...
So my calendar tables goes from 2017 to 2021. Also, I am not calculating for a year. I have chiclets that have the year and month so that the user can determine the time frame the want to look at.
Total Est Rev = sum('Quotes Estimates US'[Estimate Revenue])
Total Est Rev PY = CALCULATE([Total Est Rev],SAMEPERIODLASTYEAR('Calendar'[Date]))
See the below snap shot of the page. I also have My Quotes table linked to the Calendar table via the jobsdate. Which is where the month and year are being pulled from.