Forum Discussion

Bostox's avatar
Bostox
Regular Visitor
3 years ago
Solved

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]))
 

 

 

Need Help
  • Bostox's avatar
    Bostox
    3 years ago

    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])
        )
    )

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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.

  • Bostox's avatar
    Bostox
    Regular Visitor
    3 years ago
    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

  • Bostox's avatar
    Bostox
    Regular Visitor
    3 years ago

    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])
        )
    )