Generate dates in between values on the same column

[Victormar]

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!

[tamerj1]

HI @Victormar 
Something like this? Or you wish to have a calculated table?

[Victormar]

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]

@Victormar 

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

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

[Victormar]

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()

[KeyurPatel14]

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

[Victormar]

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]

[Victormar]

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]

))