Need help with DAX code for cumulative values

Hi honeybee84 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

johnt75 bhanu_gautam Thank you for your quick inputs.

honeybee84 Could you please try the below DAX measure.:

Cumulative Prior Month Forecast =
VAR SelectedReportingPeriod = MAX(DIM_Date[Reporting Period])
VAR PriorReportingPeriod =
CALCULATE(
MAX(DIM_Date[Reporting Period]),
DATEADD(DIM_Date[Reporting Period], -1, MONTH)
)
RETURN
CALCULATE(
[Forecast],
FILTER(
ALL(DIM_Date),
DIM_Date[Month] <= MAX(DIM_Date[Month]) 
),
TREATAS({PriorReportingPeriod}, FACT_CombinedData[Reporting Period]),
USERELATIONSHIP(DIM_Date[Month], FACT_CombinedData[Month]) 
)

Regards,

B Manikanteswara Reddy