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...
adudani
Memorable Member
Memorable MemberOdada ,
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.