Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

Previous year calculations bring back current year values :/ - help

I posted this in another thread but highlighted the issue of it not plotting correctly on a line graph - however the issue actually is both of these calcutions ie     PY Revenue = CALCULATE([Reven...
Need Help
mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
9 years ago

Does your 'Fiscal Date' have dates in it for the prior fiscal year(it must for time intelligence to work)? Is your 'Fiscal Date' calendar table related to the fact table via columns of type Date?   if not, can you try this:

 

PY Revenue = CALCULATE([Revenue], SAMEPERIODLASTYEAR('Fiscal Date'[Date]), ALL('Fiscal Calendar') )

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

that definitely shifted something however my measures are behaving different,  rushing off to a weekend away will figure it out monday, thanks for the help!

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    vanessafvg Is the issue solved now?

     

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      9 years ago

      no :(  trying a variety of things but its just not working - i really can't figure out what i am doing wrong, just throwing in things now to see what i might be doing wrong.

       

      Revenue = (CALCULATE(Sum(Registrations[MRR])) + CALCULATE(sum(Sales[RevenueNettAmount]))) - this is the base calculation

      PY Revenue = CALCULATE([Revenue], SAMEPERIODLASTYEAR('Fiscal Date'[TheDate].[Date]), ALL('Fiscal Date') )

      PY 2 = CALCULATE([Revenue], SAMEPERIODLASTYEAR('Fiscal Date'[TheDate].[Date]), 'Fiscal Date'[Calendar Year] )

      PY 3 = CALCULATE([Revenue], PARALLELPERIOD(all('Fiscal Date'[TheDate].[Date]), -1, YEAR))

       

       


       

      I do have a filter on the page which is only looking at the current fiscal year, but there is definitely data in my model that stretches back beyond the fiscal year which i thought the ALL would resolve.   It does resolve it in PY Revenue however it doens't bring it back per day it just flat lines it in one aggregaton for all time.

       

      Dont know if this makes sense?

       

       

      • MalS's avatar
        MalS
        Icon for Resolver III rankResolver III
        9 years ago

        I remember this problem from your other thread. I think this must be related to the relationships you have set up.

         

        Can you share the .pbix file (or en extract from it?). Without that it's hard to troubleshoot.