Forecasting

[victoriashenton]

Hi Everyone!

I am new to Power BI and was hoping someone could help me.

I have 3 lines on a line chart. Scheduled, deployed and to be completed. 

I would like the red line to stop at the date bin 09 Jun. How would I do this? The scheduled and to be completed I would like to stay the same.

Graph

Deployed Cumulative Quantity =

CALCULATE (

SUM ( Deployed[Count]),

FILTER (

ALL ( 'Dates'[Date (bins)] ),

'Dates'[Date (bins)] <= MAX('Dates'[Date (bins)])

)

)

Scheduled Cumulative Quantity =

CALCULATE (

SUM ( Scheduled[Count]),

FILTER (

ALL ( 'Dates'[Date (bins)] ),

'Dates'[Date (bins)] <= MAX ( 'Dates'[Date (bins)] )

)

)

To be completed Cumulative Quantity =

CALCULATE (

SUM ( 'To be Completed'[Count]),

FILTER (

ALL ( 'Dates'[Date (bins)] ),

'Dates'[Date (bins)] <= MAX ( 'Dates'[Date (bins)] )

)

)

[TeigeGao · Accepted solution]

Hi @victoriashenton ,

In your scenario, we can add the 'Dates'[Date (bins)] <= MAX('Dates'[Date (bins)] && 'Dates'[Date (bins)] <= DATE (2019,6,9)

Best Regards,

Teige