Forum Discussion
How to extend date from existing date table
Hello expert, I am using a pbi file created by others, however the date available from date table is up to 2022/12/31. could anybody instruct me how to extend the date range to future? Thank you in ...
Thank you so much for replying my question.
There is a date table in Power query, and the date was created by following, where Source =2017/01/01.
= List.Dates(Source, Number.From(DateTime.LocalNow() + #duration(0,9,0,0)) - Number.From(Source) -1 , #duration(1,0,0,0))