Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ROFELLM
Regular Visitor

cumulative count for all rows by date question

Hello all,

DAX Beginner here. I need help with a formular.

 

My dummy data:

ROFELLM_0-1701102393118.png

I'd like to have a bar chart, where it cumalates each entry. "Eingetragen am" is my date column.

What I expect: January: 2, February 2, March 3, April 4, May 4, June 5, July 5 and so on...

I don't know how to implement this. I tried to use the quick measures and came pretty close. The formular so far: 

 

CumulativeCount =

IF(

    ISFILTERED('Tabelle1'[Eingetragen am]),

    ERROR("Quickmeasures mit Zeitintelligenz können nur über die von Power BI bereitgestellte Datumshierarchie oder die primäre Datumsspalte gruppiert oder gefiltert werden."),

    CALCULATE(

        COUNTA('Tabelle1'[Name]),

        FILTER(

            ALL('Tabelle1'[Eingetragen am]),

            'Tabelle1'[Eingetragen am] <= MAX('Tabelle1'[Eingetragen am])

               )

        )

    )

 

My Date Table (calculated table)

ROFELLM_1-1701102422353.png

 

is linked like this: 

ROFELLM_0-1701170448486.png

 

 

What it looks like:

ROFELLM_2-1701102439672.png

 

if I select "show elements without values" it's not what I want 😞 

Any help is appreciated! Thanks in advance!

 

1 REPLY 1
amitchandak
Super User
Super User

@ROFELLM , better to use a date table joined with your table and use it in visual , measure and slicer

 

CALCULATE(

COUNTA('Tabelle1'[Name]),

FILTER(

ALL('Date'),

'Date'[Date] <= MAX('Date'[Date])

)

)

 

 

Running Total/ Cumulative:
https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42

 

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.