Forum Discussion
Table columns not adding past current date
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 RegardsCommunity 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.
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.
chenwu zhu,
I tried that and is pulling data from outside the filtered dates and still not calculating the forecasted days.
