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
Tavi_'s avatar
Tavi_
Frequent Visitor
2 years ago

Khushidesai0109 your formula shows me this figures

 

Greg_Deckler your formula shows me this figures

 

Both not the figures I'm looking for. De formula must ignore al the cartons before today. 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    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