Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Scope and Forecast Date intercept

Hello all, Using Jira data, I have created a basic burn up chart in Power BI. In the chart, I show the estimated story points (Scope) for the period, and completed story points. I have then includ...
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Is this what you're after?

    ForcastDate =
CALCULATE (
    MIN ( Table1[Date] ),
    FILTER ( Table1, Table1[Forecast] >= Table1[Quarterly Scope] )
)

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Is this what you're after?

ForcastDate =
CALCULATE (
    MIN ( Table1[Date] ),
    FILTER ( Table1, Table1[Forecast] >= Table1[Quarterly Scope] )
)