Difference from one month to previous

[george55]

Hi all,

Even I found a lot of examples here, nothing could solve my problem. Need the Count diffences from one month to previous month. Tried something like that (DatumId is my Date):

Count(Distinct {$<month(DatumId) = {$(=Max(month(DatumId)) -1), State={'aktiv'}}>} Key])

Instead to show the total number of Distinct Keys per Month, would like to show only the difference to previous month.

[sonkumamon]

Hi,

Please try

Count(Distinct {$<month(DatumId) = {$(=Max(month(DatumId))), State={'aktiv'}}>} Key])

-

Above(Count(Distinct {$<month(DatumId) = {$(=Max(month(DatumId))), State={'aktiv'}}>} Key]))

[george55]

Thanks for your help.

Did try, but doesn't look good. It shows only one month and the the chart is empty. Did also try with Monthend function: