Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
littlemojopuppy's avatar
littlemojopuppy
Community Champion
6 years ago

Check 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... 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.
    • tex628's avatar
      tex628
      Community Champion
      6 years ago

      Try 
      Total Est Rev PY = CALCULATE([Total Est Rev],ALL('Calendar'),SAMEPERIODLASTYEAR('Calendar'[Date]))

      If im not misstaken you have a doublesided crossfilter relationship between your calendar and your facts table. This should be the reason that your measure isn't working without the ALL() statement. 

      Br, 
      J

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        That is still resulting in the amounts being the same. I even changed the year to double check that I have plenty of data for 10/18 and I do. This is what my relationship between the quotes table and the calendar looks like. Any other thoughts? What is messed up is that in my jobs table I am doing the exact same thing with est and act revenue and it is working fine.