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
Khushidesai0109's avatar
Khushidesai0109
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

Hii You can use this DAX Instead
Forecast Cartons Cumulative =
CALCULATE (
[_Forecast Cartons],
FILTER (
ALLSELECTED ( '[DIM] Date'[Date] ),
'[DIM] Date'[Date] <= MAX ( '[DIM] Date'[Date] )
)
)

If this solution helped you please give a thumbs up and accept this reply as a solution!!
Thank You!! Regards!!