RunningTotal grouped by DateTable

[GeDei]

Hallo,

I'm trying to visualize a RunningTotal(RT) in Power BI.
It is created by using the quick measure running total and distinct vlaue of contact id and createdon 

So far so good. It works like intended and I can visualize it. Now I would like to group it for Month. 

I tryed to create a second column from createdon and Format it "MMMM". But then the calculation does not show the RT but the distinct value per Month.

I created a Date-Table and linked it to the contact table.

Now I'm stuck to use the date table in the vusiual. 

I can't figure out to group it proper to show the RT by Month and sort Month in the right order

Maybe someone has an idea.

KR

GeDei

[amitchandak · Accepted solution]

@GeDei , can share what is wrong. As MMMM does not take the case of year that part I expect that to be wrong here

[GeDei]

@amitchandak 

Thanks for your response. I acutally did not test your answer but went another way. Which I think still shows that you are correct. 

I created with the Option Data Groups a Column were Power BI created for me "Month Year"

Using this column works 

Still have a Problem. When I try to select just the actual year for the filter on visual it shows the actual year and only the values for this year. But as it is a running total I would like to see the actual year with the summirzed values from the previous year. 

EDIT:

By changeing ALLSECLECTED to ALL no Filter will be accepted by the Measure.

_RT ContactID =

CALCULATE(

    DISTINCTCOUNT('Contact'[contactid]),

    FILTER(

        ALL('Contact'[createdon (bins)]),

        ISONORAFTER('Contact'[createdon (bins)], MAX('Contact'[createdon (bins)]), DESC)

    )

)