Sum of future total

[DanielSilvaP8]

I'm using the measurement in DAX and it only works for the past few weeks. When it is future weeks, the Total is not correct.

Measurement: 

Estoque APAGAR =

// Pega Último Estoque Lançado

VAR vLastNonBlank =

    CALCULATE(

        [Estoque Atual],

        LASTNONBLANK(

            ALLSELECTED(_dCalendario[Num_Semana], _dCalendario[NumeroDoMes (445)]),

            [Estoque Atual]

        )

    )

// Pega a última maior data da última semana com valor de estoque total, precisaremos dela nos cálculos de acumulados

VAR vLastDayNonBlank =

    CALCULATE(

        MAX(_dCalendario[Num_Semana]),

        LASTNONBLANK(

            ALLSELECTED(_dCalendario[Num_Semana], _dCalendario[NumeroDoMes (445)]),

            [Estoque Atual]

        )

    )

// Maior data do contexto atual... Acumularemos da última data preenchida até esta data.

VAR vMaxData = MAX(_dCalendario[Num_Semana])

// Acumulado da medida Rolling Forecast

VAR vRollingAcumulado =

    CALCULATE(

        [Rolling Forecast],

        _dCalendario[Num_Semana] >= vLastDayNonBlank && _dCalendario[Num_Semana] <= vMaxData,

        ALLSELECTED(_dCalendario[NumeroDoMes (445)])

    )

// Acumulado da medida Projeção de Compras

VAR vProjCompraAcumulada =

    CALCULATE(

        [Projeção de Compras],

        _dCalendario[Num_Semana] >= vLastDayNonBlank && _dCalendario[Num_Semana] <= vMaxData,

        ALLSELECTED(_dCalendario[NumeroDoMes (445)])

    )

// Valor calculado

VAR vValor =

    vLastNonBlank + vProjCompraAcumulada - vRollingAcumulado

RETURN

IF(

    ISBLANK([Estoque Atual]) || [Estoque Atual] = 0,

    vValor,

    [Estoque Atual]

)

[Greg_Deckler]

@DanielSilvaP8 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[DanielSilvaP8]

https://docs.google.com/spreadsheets/d/e/2PACX-1vRcp19fW-VpKSVGHpTWHNKClEKlHWJm2d4DNG0jedp7HLvtCFXik...