Skip to main content
cancel
Showing results for 
Search instead 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

Reply
MiKeZZa
Post Patron
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
v-yuezhe-msft
Microsoft Employee
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.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft Employee
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.

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors