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