Forum Discussion

Victormar's avatar
Victormar
Helper 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 Country Fleet name Onboarding Unboarding Total
2022-04-22 Bus SWE Swe2 1 0 1
2022-04-30 Bus SWE Swe2 2 0 3
2022-05-12 Bus SWE Swe2 0 1 2
2022-04-10 Bus BEL BEL1 3 0 3
2022-04-15 Bus BEL BEL1 1 0 4
2022-04-23 Bus BEL BEL1 5 0 9
2022-05-01 Bus NLD NLD2 6 0 6
2022-05-17 Bus NLD NLD2 0 2 4

 

I would like to replicate the dates in between, so I could show the evolution over time.

 

Hope it makes sense. Thanks for any help 🙂

 

Wish you a lovely day!

dates
DAX
Help

8 Replies

    • Victormar's avatar
      Victormar
      Helper V
      3 years ago

      That looks good, I tried to do it with a line chart but I couldn't see the evolution, it looked like:

      Is it possible to replicate it up until today? I tried modifying your measure for the current date, but didn't change.

       

      Thanks again tamerj1 

      • tamerj1's avatar
        tamerj1
        Community Champion
        3 years ago

        Victormar 

        Only change the last date of the date table to today like

        CALENDAR ( MIN ( 'Table'[Date] ), TODAY ( ) )

    • Victormar's avatar
      Victormar
      Helper 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 🙂