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])
    )
    )

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

you DAX should work fine.please see the attachment.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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