PREVIOUSYEAR not returning data

[kozlevchar]

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 · Accepted solution]

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

[littlemojopuppy]

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]

Hi,

Thank you for the reply.  I have  Date table and it's marked as a Date Table

[littlemojopuppy]

@kozlevchar can you share the pbix?