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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Bostox
Regular Visitor

Cummulative Count by Date with Dates

hi power bi community

I've searched the forum looking for an answer but couldn't find any.
so i have to ask you

I have a Timestamp Database with date and time HH:MM:SS making requests that are difficult to repeat

I can do a pretty easy daily/monthly/yearly count with just this table, but I don't know how to do a cumulative count
Medida = CALCULATE(
COUNT(
Documentos[Fecha Salida Planta]),
FILTER(ALLSELECTED(Documentos),
MAX([Fecha Salida Planta]) >= [Fecha Salida Planta]))
 
Bostox_0-1681851917065.png

 

 

1 ACCEPTED SOLUTION
Bostox
Regular Visitor

Found Solution

 

Work with Filters and Delete Blank Data

 

Responsive Cummulative =

CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date] <= MAX('Table'[Date]) && NOT(ISBLANK('Table'[Date]))
    )
)
 
In case you dont need delete blank data
 

Responsive Cummulative =

CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date] <= MAX('Table'[Date])
    )
)

View solution in original post

3 REPLIES 3
Bostox
Regular Visitor

Found Solution

 

Work with Filters and Delete Blank Data

 

Responsive Cummulative =

CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date] <= MAX('Table'[Date]) && NOT(ISBLANK('Table'[Date]))
    )
)
 
In case you dont need delete blank data
 

Responsive Cummulative =

CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Date] <= MAX('Table'[Date])
    )
)
Bostox
Regular Visitor

Numero CamionCodigoFecha Salida Planta
9729200925624013-04-2023 13:30

 

Sorry didnt read those post, only looked for some others asking related questions

 

So i want to go from Count to Cummulative count as shown in the pic above, all of this for looking the producction levels on different years.

tried with sum but im not looking for profits so i changed to count by data entrace

 

sorry if this is not enought info

Greg_Deckler
Community Champion
Community Champion

@Bostox Sorry, what does your base data look like? Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors