Date supporting table - Range Update

[LucaB72]

Dear all,
I am suing the query shared by Enterprise DNA to create a date table (that i call dDate)

I create my report and use as template when need to run on other data set.

Other dataset have a different range of date and the dDate table start and finish date need to be changed (expanded/contracted)

Could please share the method to follow to keep the various relationship already created in the Power BI model?

Thanks
Luca

[LucaB72]

Sorry I know the solution to go and edit the query for the dDate and inside the M code to change manually the start and end date.

Was wondering if there is any more automatic way to perform it

Thanks
Luca

[Harsh]

Hello @LucaB72,

Thank You for posting your query onto the Forum.

Sam Sir has created a video based onto the topic about to create a “Dynamic Table Table”. I’m providing a link of a video below.

Hoping you find this useful.

Thanks and Warm Regards,
Harsh

Creating a Dynamic Date Query Table in Power BI - Query Editor Tutorial

[BrianJ]

@LucaB72,

In addition to the video @Harsh recommended, there is also an epic post by @Melissa on this topic that addresses all aspects of this question in a really clear way:

Creating a dynamic Start-/EndDate for the Date table

Hi everyone, To make it easier to find here are some Power Query techniques to make the Date table Startdate and/or Enddate dynamic. If you want to give that a try, go to Power Query, select New Source, Blank Query, open the Advanced Editor, paste in this Date table M code and Invoke that function. A new query will appear in the Queries pane with the name ‘Invoked Function’ in the formula bar of that query’s Source step you can distinguish the following elements. Date table function query na…

• Brian

[EnterpriseDNA]

Hi @LucaB72, did the response provided by the users and experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

[EnterpriseDNA]

Hi @LucaB72, we’ve noticed that no response has been received from you since the 19th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

[EnterpriseDNA]

Hi @LucaB72, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!