Table columns not adding past current date

[geochick_ID]

I am building a table to forecast the end of the month. The Forecasted total Mined is the sum of the previous 2 columns. I am not sure why the daily numbers are showing correctly but the totals and the cumulative do not calculate correctly past the last total tons date.   

[v-chenwuz-msft · Accepted solution]

Hi @geochick_ID ,

You need to use SUMMARIZE() to create a virtual table in measure. This virtual table should be constructed to look like your table visual.

Total =
VAR _s =
    SUMMARIZE (
        'table',
        [date],
        "remaining days", [measure_remaining days],
        "forecast total", [measure_forecast_total]
    )
RETURN
    SUMX ( _s, [forecast total] )

cumulative =
VAR _s =
    SUMMARIZE (
        FILTER ( ALLSELECTED ( 'table' ), [date] <= MAX ( 'table'[date] ) ),
        [date],
        "remaining days", [measure_remaining days],
        "forcaset_cumulative", [measure_cumulative]
    )
RETURN
    SUMX ( _s, [forcaset_cumulative] )

Best Regards

Community Support Team _ chenwu zhu

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

[geochick_ID]

chenwu zhu,

I tried that and is pulling data from outside the filtered dates and still not calculating the forecasted days.