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]))
     
aj1973's avatar
aj1973
Community 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
    Community 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?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      No Calendar table.

      • aj1973's avatar
        aj1973
        Community Champion
        5 years ago

        Indeed,

        Now Add a calendar table and join it to RADsNew at Created column