Forum Discussion

Tavi_'s avatar
Tavi_
Frequent Visitor
2 years ago
Solved

Cumulative Cartons Forecasted

Hi, I use this formula for the cumulative total of forecasted cartons. _Forecast Cartons Cumulative = CALCULATE( [_Forecast Cartons],     FILTER(         ALL('[DIM] Date'[Date]),         '[D...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Tavi_ OK, didn't understand that from the original post:

    _Forecast Cartons Cumulative = 
VAR __Value = CALCULATE(
[_Forecast Cartons],
    FILTER(
        ALL('[DIM] Date'[Date]),
        '[DIM] Date'[Date] <= MAX ('[DIM] Date'[Date]) && '[DIM] Date'[Date] >= TODAY() )
)
VAR __Result = IF( MAX('[DIM] Date'[Date]) < TODAY(), BLANK(), __Value )
RETURN
__Result
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

Tavi_ 

_Forecast Cartons Cumulative = 
VAR __Value = CALCULATE(
[_Forecast Cartons],
    FILTER(
        ALL('[DIM] Date'[Date]),
        '[DIM] Date'[Date] <= MAX ('[DIM] Date'[Date]))
)
VAR __Result = IF( MAX('[DIM] Date'[Date]) < TODAY(), BLANK(), __Value )
RETURN
__Result