Forum Discussion

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
10 years ago
Solved

Percentage difference Previous Year - No dates

Hi All,   I'm trying to create measures to calculate year on year % difference. (should be simple but its Friday :smileyhappy:)   As it stands my data does not have dates, just a year identifier ...
Need Help
  • itchyeyeballs's avatar
    itchyeyeballs
    10 years ago

    Got there in the end (funny how typing something out gets you to think)

     

    Changed the formula to: 

     

    Calculate(SUM(Profile[I_FTE]),previousyear('Calendar'[End Date],"August 31"),all('Calendar'))

     

    and fixed the link that broke when I reimported my lookup table and hey presto

     

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
10 years ago

I have now added start date and end date fields to my lookup so there is a notional real date attached to my data, however the measure is blank when retrned in a matrix.

 

Code used is:

 

Calculate(SUM(Profile[I_FTE]),previousyear('Calendar'[End Date],"August 31"))

 

'Calendar'[End Date] is a date/time field

 

SUM(Profile[I_FTE]) works on its own

 

Any ideas?

  • itchyeyeballs's avatar
    itchyeyeballs
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    Got there in the end (funny how typing something out gets you to think)

     

    Changed the formula to: 

     

    Calculate(SUM(Profile[I_FTE]),previousyear('Calendar'[End Date],"August 31"),all('Calendar'))

     

    and fixed the link that broke when I reimported my lookup table and hey presto