Forum Discussion

Odada's avatar
Odada
Regular Visitor
3 years ago

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...
Need Help
Tips and Tricks
latimeria's avatar
latimeria
Solution Specialist
3 years ago

Hi Odada  ,

Try this

 

List.Dates([Targetdate] ,Number.From([EndTargetdate]-[Targetdate])+1,#duration(1,0,0,0))

 

 

Odada's avatar
Odada
Regular Visitor
3 years ago

Thank you so much latimeria