Reply
Member
Posts: 106
Registered: ‎12-27-2016
Accepted Solution

How to SUM amount in the next three month

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!

 

2018-05-21 17_23_58-User and Portal User License Insights - Power BI Desktop.png


Accepted Solutions
Community Support Team
Posts: 7,624
Registered: ‎05-02-2017

Re: How to SUM amount in the next three month

[ Edited ]

Hi @regasanyoto,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 7,624
Registered: ‎05-02-2017

Re: How to SUM amount in the next three month

[ Edited ]

Hi @regasanyoto,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Member
Posts: 106
Registered: ‎12-27-2016

Re: How to SUM amount in the next three month

Thanks, it works!