formula for Month-on-Month measure in trend line chart

[newbie_sm]

I am trying to create a Month-on-Month trend line chart with the following formula but no data is generated.

(

Count ({$<[DTE_YR-MTH]={"=$(=Max([DTE_YR-MTH]))"}>} Distinct[User Name])

/

Count({$<[DTE_YR-MTH]={"=$(=Max([DTE_YR-MTH])-1)"}>} Distinct[User Name])

)

-1

Please advise what is wrong with this expression, thanks

[BrunPierre]

Hi, could it be that the month field is interpreted as text? Try something like this.

[DTE_YR-MTH]={'$(=Date(Max(Date#([DTE_YR-MTH],'MMMM')),'MMMM'))'}

[newbie_sm]

this doesn't work