Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate previous month total when dates are multiple

Hi, 

I am calculating total of previous month with condition. I am getting error as below

Need Help
  • aj1973's avatar
    aj1973
    5 years ago
    Previous Month = CALCULATE(COUNT(RADsNow[Number]), PREVIOUSMONTH('Created Date' [Date]))
     

16 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous 

    You need a Calendar table to be able to use Time intelligence functions. your current date column contains duplicate values.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      aj1973 ,

      How to solve this ?

      I need it in a measure 

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        5 years ago

        I just told you, You need a Calendar table in your model. Do you have a Calendar table in your model?

        Can you screen shot your model?