DAX - Running total over months

Question

I'm trying to present a running total. That is made with these DAX-formula (which I see on many places):&nbsp;RT = SUMX(FILTER(ALL('table'[startdate].[Date]),'table'[startdate].[Date]&lt;=MAX('table'[begindate].[Date])),'table'[unique days])&nbsp;unique days =&nbsp;&nbsp;DISTINCTCOUNT('fact'[client_date_unique])&nbsp;But presenting these formula gives:&nbsp;CustomerName &nbsp; &nbsp; &nbsp;Month &nbsp; &nbsp; &nbsp; &nbsp; RTPeet &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-2017 &nbsp; &nbsp; &nbsp; 31Peet &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02-2017 &nbsp; &nbsp; &nbsp; 28Peet &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03-2017 &nbsp; &nbsp; &nbsp; 31While I was expecting:CustomerName &nbsp; &nbsp; &nbsp;Month &nbsp; &nbsp; &nbsp; &nbsp; RTPeet &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-2017 &nbsp; &nbsp; &nbsp; 31Peet &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02-2017 &nbsp; &nbsp; &nbsp; 59Peet &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03-2017 &nbsp; &nbsp; &nbsp; 90&nbsp;Can somebody tell me what's wrong with my DAX-statement(s)?

anonymous · Accepted Answer

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]&lt;=MAX('table'[startdate])),'table'[unique days])
Regards,Lydia

Forum Discussion

DAX - Running total over months

2 Replies

Related content

Running Total Per Month

Running Totals

Running total

Waterfall Charts with running totals

Tableau to PowerBI Running Totals Issue