Forum Discussion

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago
Solved

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'[beg...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
MiKeZZa
Post Patron
9 years ago

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