Forum Discussion

Victormar's avatar
Victormar
Icon for Helper V rankHelper V
3 years ago

Generate dates in between values on the same column

Hello community, I have a table with a counter on the number of vehicles and the date, and I would like to create the counting up until today, if possible. Say I have: Date Brand Countr...
dates
DAX
Help
Victormar's avatar
Victormar
Icon for Helper V rankHelper V
3 years ago

Hello, yes! For example, for the first fleet Swe2, it would be:

 

Date Brand Country Fleet Name Onboarding Unboarding Total
2022-04-22 Bus SWE Swe2 1 0 1
2022-04-23 Bus SWE Swe2 0 0 1
2022-04-24 Bus SWE Swe2 0 0 1
2022-04-25 Bus SWE Swe2 0 0 1
2022-04-26 Bus SWE Swe2 0 0 1
2022-04-27 Bus SWE Swe2 0 0 1
2022-04-28 Bus SWE Swe2 0 0 1
2022-04-29 Bus SWE Swe2 0 0 1
2022-04-30 Bus SWE Swe2 2 0 3

 

I hope it makes sense, it's to make a cumulative over time, if that makes more sense.

 

Thanks for your time KeyurPatel14 

 

Editing after tamerj1 answer, I would like the totals to replicate up until today 🙂

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

 

 

  • Victormar's avatar
    Victormar
    Icon for Helper V rankHelper V
    3 years ago

    I must be doing something wrong, because I don't get the same results:

     
    Fleet History Date = CALENDAR ( MIN ( 'Fleet History'[date_analysis] ), MAX('Fleet History'[date_analysis]))
     
    TTL = CALCULATE(
        LASTNONBLANKVALUE(
            'Fleet History Date'[Date], SUM('Fleet History'[tot_fleet_size_to_date])),'Fleet History Date'[Date] <= MAX('Fleet History Date'[Date]
    ))