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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors