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

    • littlemojopuppy's avatar
      littlemojopuppy
      Community Champion
      6 years ago

      Can you share the PBIX file?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        How do I do that safely?

    • tex628's avatar
      tex628
      Community Champion
      6 years ago

      Try changing the format of the 'Calendar'[Date] column to Date isntead of DateTime. Looks like there might be an issue with the dataformatting.

      / J

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I did that and it is still giving me blank as my results for the prior year. I am doing the exact same thing I have done before I just go not understand what the issue is.