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
KeyurPatel14's avatar
KeyurPatel14
Icon for Responsive Resident rankResponsive Resident
3 years ago

Hi Victormar ,
Can you please sample output so that I can help you quickly?

 

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