cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Patron

## DAX - Running total over months

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)?

1 ACCEPTED SOLUTION
Microsoft Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Microsoft Employee

@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

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

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