How to SUM amount in the next three month

[Anonymous]

Hello guys,

I would like to know how to calculate the total initial after three months.

The measure of Initial  is :

CALCULATE(DISTINCTCOUNT('Fact User License'[ObjectId]),

                                       FILTER('Fact User License','Fact User License'[InitialDate] = "1")
                             )

In the image below there must be a new column based on the total Initial after three months. 

The expected result for the first row with this new measure must be  14. This because 8 (2018/01)    + 3 (2018/02)  + 3 (2018/03) = 14.

any suggestion to create a new measure or calculated column to realize the total initial amount after first three months?

Thanks in advaced!

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Try the formula below please.  A date table is needed if you don't have one.

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Fact User License'[ObjectId] ),
    DATESINPERIOD ( 'datetable'[date], FIRSTDATE ( 'datetable'[date] ), 3, MONTH ),
    FILTER ( 'Fact User License', 'Fact User License'[InitialDate] = "1" )
)

Best Regards,

Dale

[Anonymous]

Thanks, it works!