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

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
Icon for Community Champion rankCommunity 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
    Icon for Helper V rankHelper V
    3 years ago

    I did, but it doesn't seem to apply :S.

     

    Ideally I want a line chart, and it looks like: 

    My calendar table:

    Fleet History Date = CALENDAR ( MIN ( 'Fleet History'[date_analysis] ), TODAY())
    I have also changed it in the formula, so date is <= today()