Forum Discussion
Dynamic Interval for Schedule Modelling (repost from Developer)
Hi derekalstein ,
According to your statement, I think [varFinish] is a calculated column and you want it to be dynamic by "Duration" slicer. [Duration Value] in [varFinish] column should be a measure which is filtered by "Duration" slicer.
As far as I know, Power BI doesn't support us to create a calculated column which will be dynamic filtered by slicer. Here I suggest you to create a measure instead of a calculated column. Then show measure in a visual. And I see you use Dateadd() function and time intelligence Outages[Start Date].[Date] from your screenshot.
As far as I know, Dateadd() will return a table. .[Date] may not be a good idea due to it will make your report complex.
Try below code to create a measure.
varFinish = SELECTEDVALUE(Outages[Start Date]) + [Duration Value]
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.