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
Odada's avatar
Odada
Regular Visitor
3 years ago

Thank you for your reply, i have tried it and it returned only 1/1/2023

Is there something i can do pls

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