Forum Discussion

RossBateman96's avatar
1 year ago
Solved

List.Dates function- Count error

Hi

As an example, I have a table in the below format.

PeriodstartingDateendingDate
P101/01/202428/01/2024
P229/01/202425/02/2024
P326/02/202431/03/2024

 

I want to create a table that has every date allocated to a period. I have created a custom column as per the below:

 

Table.AddColumn(#"Removed Columns", "Custom", each List.Dates([startingDate], Number.From([endingDate]-[startingDate])+1, #duration(1,0,0,0)))

 

This gives the desired output but when trying to apply these changes it comes back with the following error.

OLE DB or ODBC error: [Expression.Error] The 'count' argument is out of range..

 

I can't work out why this is, does anyone else know?

 

Thanks in advance,

Ross

 

  • RossBateman96 , try using below mentioned code

     

    Table.AddColumn(#"Removed Columns", "Custom", each if Number.From([endingDate] - [startingDate]) >= 0 then List.Dates([startingDate], Number.From([endingDate] - [startingDate]) + 1, #duration(1,0,0,0)) else null)

1 Reply

  • RossBateman96 , try using below mentioned code

     

    Table.AddColumn(#"Removed Columns", "Custom", each if Number.From([endingDate] - [startingDate]) >= 0 then List.Dates([startingDate], Number.From([endingDate] - [startingDate]) + 1, #duration(1,0,0,0)) else null)