Create Column as List of Values using M

Hello ImkeF ,

After watching Curbal's video link, I copied and pasted your raw function code into a new blank query.  I invoked the function to test it and it works just fine.

As a newbie to this community, I haven't yet figured out how to share my pbix file so will try to describe best I can

I created a new query with the following syntax:

=Table.SelectColumns(Import_Recur,{"Record No.","Project Amount","Contract Start Date","Contract Expiration Date"}) and generated a small table with 9 records.  Sample as follows:

Record No.Project AmountContract Start DateContract Expiration Date

I then followed with the code from the blog post that I think is what I need to use.

= Table.AddColumn(Source, "ListofDates", each Date.DatesBetween([Contract Start Date],[Contract Expiration Date],"Month"))

But I get the following error message.

Expression Error: The name 'Date.DatesBetween wasn't recognized.  Make sure it is spelled correctly.

I must be missing a step somewhere, but am stuck as to where I turn to next.  Not sure if it has to do with my Column Names or placing the function code in the right place.

Based on invoking the function, this is exactly the solution I am looking for.  I just need some guidance on how to get it to execute on my data table.

Thank you so much for your help.