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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.