Forum Discussion

kozlevchar's avatar
kozlevchar
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]) , PREVIOU...
Need Help
  • kozlevchar's avatar
    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

kozlevchar's avatar
kozlevchar
Resolver I
4 years ago

Hi,

 

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