Trying to create Date Table in power query using M

[Dicken]

Hello all,
I've been trying to create a date table in power query but am getting continual errors ;
I've loaded a small table into power query and then used blank query ; =List.Min(Table1[Date]) to return lowest date then added step List.Max(Table1[Date]), to return hightest date; The first step is left as 'source' and the second renamed finish
I then try to add the third step ;

List.Dates(Source,Duration.Days(Finish-Source)+1,#Duration(1,0,0,0)), I've tried #duration(1,0,0,0)

I've attached the file, any help or advice gratefully received.

Richard.

[rorya]

Source should be: = Date.From(List.Min(Table1[Date]))
Similarly, Finish should be: = Date.From(List.Max(Table1[Date]))
Then your list is: = List.Dates(Source,Duration.Days(Finish-Source)+1,#duration(1,0,0,0))

[Dicken]

Thanks Rory,

Richard.

[rorya]

Glad we could help.