Dynamic Interval for Schedule Modelling

[derekalstein]

Hello - first time poster. Before you get angry, I have read through the forums and not been able to find a solution that works.

Here's what I'm trying to do.

For a number of projects with defined start dates over the next 30 years, I want to create a data modeller that allows me to flex project duration to recalculate finish date and total duration over the life of the facility (total project days). There are number of various scenarios in durations that can be considered, and i'd like to use this data modeller to reshoot a gantt chart.

I started by building a parameter with a defined range (days). This parameter, and the associated measure, was meant to be used for the Duration Value to determine a new finish date for each scheduled project.

my formula...

varFinish = dateadd(Outages[Finish Date], [Duration Value], day)

where...

- [Finish Date] is a predefined project date

- [Duration Value] is the measure being generated by the parameter

This formula was used for a column in my table to assign a new finish date to each specific project. It doesn't seem to recognize the [Duration Value] as a number. But when i manually change the [Duration Value] to a simple integer (1, 5, 4005, whatever), the finish date updates by the associated days.

I'm stumped and getting angry (mainly because i could build the same functionality in excel in a matter of minutes)

please help!

TIA!

[v-jianboli-msft]

Hi @derekalstein ,

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[derekalstein]

I hope this helps...

The problem seems to lie in the varFinish code. The interval value (in days) is being set by Outage[Duration Value], which is linked to a parameter between 10-40. When I use this reference to the dynamic value, the new date (varFinish) does not move from the start date - ie the number seems to be recognized as 0. But if i manually change the internval reference from Outage[Duration Value] to just a random number, the formula properly moves the date by that number of defined days.