DAX - Running total over months

[MiKeZZa]

I'm trying to present a running total. That is made with these DAX-formula (which I see on many places):

RT = SUMX(FILTER(ALL('table'[startdate].[Date]),'table'[startdate].[Date]<=MAX('table'[begindate].[Date])),'table'[unique days])

unique days =  DISTINCTCOUNT('fact'[client_date_unique])

But presenting these formula gives:

CustomerName      Month         RT

Peet                        01-2017       31

Peet                        02-2017       28
Peet                        03-2017       31

While I was expecting:

CustomerName      Month         RT

Peet                        01-2017       31

Peet                        02-2017       59
Peet                        03-2017       90

Can somebody tell me what's wrong with my DAX-statement(s)?

[Anonymous · Accepted solution]

@MiKeZZa,

Please check if the following DAX returns your expected result, if not, please share sample data of your table for us to analyze.

RT = SUMX(FILTER(ALL('table'[startdate]),'table'[startdate]<=MAX('table'[startdate])),'table'[unique days])

Regards,
Lydia

[MiKeZZa]

Thank you, this works.... I don't see the (real) difference with my DAX, but I'm very glad with this 🙂