creating a column with all dates between a start- and an enddate using the "new column" function

[Dave_Delfino]

Hey Guys,

I'm trying to visualise a project buffer consumption where the timeline reaches from the project startdate to the project enddate. The problem is that i want to create the timeline-column with the "new column" operation using something like "datesbetween() etc."

getting back a table where a column is needed...

Has anybody an idea how to tackle this problem?

greetings,

David

[v-chuncz-msft]

@Dave_Delfino,

You may use DATEDIFF Function.

Column =
DATEDIFF ( Table1[startdate], Table1[enddate], DAY )

[Dave_Delfino]

Hello Sam,

using the Datediff function gives me back a column where every row contains the NUMBER of days between the two dates. What I need is a column containing every single date between the Start- and Enddate. e.g.: 01.01.2000 / 02.01.2000 / 03.02.2000...etc.

The Datesinbetween function seems to do the job, but i won't get it working 😕

[v-chuncz-msft]

@Dave_Delfino,

You may add calculated tables.

Calendar =
CALENDARAUTO ()

Table =
GENERATEALL (
    Table1,
    SELECTCOLUMNS (
        DATESBETWEEN ( 'Calendar'[Date], Table1[startdate], Table1[enddate] ),
        "Date2", 'Calendar'[Date]
    )
)

[Dave_Delfino]

Hey Sam,

That was the work around i allready did and made the screenshot of. I am trying to solve it only using the "new column"- formulas. There must be a way doesn't it?

greetings,

Dave

[Dave_Delfino]

Hey Sam,

i just saw that i never attached the screenshot i spoke about.

Here you go:

the work around i talked about...

but this still isn't the answer i',m looking for...