Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


Cumulative count in matrix filtered by date

Good afternoon, I would appreciate it very much if you can help me

The case is as follows:

I have two tables with data

The first table is:


from where we will take the categories for the matrix.

The second table is:


From this we will take those that are from July 1 and 2, 2022.

What I am looking for is to be able to make the following matrix:


What I need is for July 2, 2022 to add the value of the previous day plus the value of July 2.

Please note that from table 2 there is data from other dates which I do not want to bring to the matrix and that I would prefer to do it within the DAX formula and not with external filters.

One more doubt: if you wanted to bring the accumulated of the previous month, that is, the figure of 30/06/2022, it can be done and how it would be done???.

I thank you for the yuda.

Super User
Super User

Hi @Syndicate_Admin ,


You can do something like

cumulative sum =
    SUM ( table[value] ),
    FILTER (
        ALL ( table[date] ),
        table[date] <= MAX ( table[date] )
    ) //to create a sum of values where  date is less than or equal to the date in the current filter context

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Connect to me on LinkedIn || Need consulting? Hire me for a Power BI gig on UpWork.
Learn with me on YouTube @PowerBITambayan.

Thank you very much, I already tried the formula, but it does NOT work, for some reason I accumulate the figures since 2020 by category but does not filter me those of the month.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors