Forum Discussion
Challenge returning dates between my startdate and enddate in power query
Good day all,
pls i have a challenge trying to get the dates in between my start and end date, i used the custom column M function {Number.from{startdate}..{number.from{enddate} and it gives me the following error
Expression error, we cannot apply an index of a type date
details=[function]
Index= 1/1/2023
5 Replies
Odada ,
create a column subtracting the two dates you want to find the range between by selecting both columns and "From Date& Time" -> Date -> Subtract Days.Then create a custom column using:
List.Dates({startdate, subtraction, #duration(0,0,0,1)})
Please accept this as the solution if this resolves your question.Appreciate a thumbs up if this is helpful.
Thank you for your reply, i have tried it and it returned only 1/1/2023
Is there something i can do pls
Thank you for your reply, i have tried it and it returned only 1/1/2023
Is there something i can do pls
