Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative Sum using DAX

Hi All,   I have my data as below.   ID OUTPUT_TYPE FORECASTED_MONTH FORECAST_QTY Cumm. FORECAST_QTY 1 NOMINAL 3 26 26 1 NOMINAL 6 27 54 1 NOMINAL 9 28 82 1 NOMINA...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

    Cummulative Qty New =
    CALCULATE(
    SUM('Forecasting'[FORECAST_QTY]),
    FILTER(
    allselected('Forecasting'),'Forecasting'[ID],'Forecasting'[OUTPUT_TYPE] max('Forecasting'[OUTPUT_TYPE]) &&
    'Forecasting'[FORECAST_MONTH] <= MAX('Forecasting'[FORECAST_MONTH])
    )
    )

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

Cummulative Qty New =
CALCULATE(
SUM('Forecasting'[FORECAST_QTY]),
FILTER(
allselected('Forecasting'),'Forecasting'[ID],'Forecasting'[OUTPUT_TYPE] max('Forecasting'[OUTPUT_TYPE]) &&
'Forecasting'[FORECAST_MONTH] <= MAX('Forecasting'[FORECAST_MONTH])
)
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago
    Hi amitchandak , 
     
    I have tried like below. But it is not working as expected.
     
    Cummulative Qty New = CALCULATE(
    SUM('Forecasting'[FORECAST_QTY]),
    FILTER(
    ALLSELECTED('Forecasting'),'Forecasting'[ID] = SELECTEDVALUE('Forecasting'[ID]) &&
    'Forecasting'[OUTPUT_TYPE] = max('Forecasting'[OUTPUT_TYPE]) &&
    'Forecasting'[FORECAST_MONTH] <= MAX('Forecasting'[FORECAST_MONTH])
    )
    )
     
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you amitchandak, it is working as expected. I had additional columns and hence it was not coming. Now I have removed and it is working fine