Count previous months

Hi Dicken 

Can you please try this measure

Count Previous Months=
CALCULATE(DISTINCTCOUNT('Calendar'[Month Number]),FILTER(ALL('Calendar'),
'Calendar'[Date]<=MAX('Calendar'[Date])),
KEEPFILTERS('Sales'))

hi Dicken ,

try like:

Count Previous Months:=

VAR Myear =

    IF( 

     HASONEVALUE( 'Calendar'[Year]),

     VALUES( 'Calendar'[Year])

)

VAR Mmonth = 

    IF (HASONEVALUE( 'Calendar'[Month Number]), VALUES('Calendar'[Month Number]))

RETURN

CALCULATE (

    COUNTROWS ( 'sales'),   

      FILTER(ALL('Calendar'), 'Calendar'[Month Number]<= Mmonth && 'Calendar'[Year] = Myear))

Thank you all, I'll work through all of them.