Forum Discussion

Resolver I

4 years ago

Solved

PREVIOUSYEAR not returning data

PREVIOUSYEAR (Doesn't fail but returns no data). The Date column in my Calander is set to "Date". Here's the formula:

Spend PY = CALCULATE(SUMX('Key Measures', 'Key Measures'[Spend]) , PREVIOUSYEAR('Calendar'[Date]))

Any help/ideas would be much appreciated.

Thanks,

John

kozlevchar
4 years ago
Thank you for the reply. I kept working with it and when I took the SUMX out fo the formula it worked and now shows data. Don't quite understand why as I thought you had to use another formulas with CALCULATE.

Thanks,

John

4 Replies

littlemojopuppy
Community Champion
4 years ago
Hi kozlevchar check that you have a date table and that it's marked as one. PREVIOUSYEAR is a time intelligence function and requires a date table in order to work properly.
- kozlevchar
  Resolver I
  4 years ago
  Hi,
  
  Thank you for the reply. I have Date table and it's marked as a Date Table
  - littlemojopuppy
    Community Champion
    4 years ago
    kozlevchar can you share the pbix?
kozlevchar
Resolver I
4 years ago
Thank you for the reply. I kept working with it and when I took the SUMX out fo the formula it worked and now shows data. Don't quite understand why as I thought you had to use another formulas with CALCULATE.

Thanks,

John

Related content