Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
newrice
Frequent Visitor

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 advance,

2 REPLIES 2
newrice
Frequent Visitor

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)) 

Idrissshatila
Super User
Super User

Hello @newrice ,

 

Go to the date table and click on the date column in the data view , it should show you a measure, so you can modify the end date in the measure.

 

If it didn't show you a measure, then it may be done in power query, so go to the transformation tab and check the date table in Power query.

 

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.