Fill "empty" months with previous accumulated values

[Rflad]

Trying to fill an accumulated stacked chart with values, months that have no values. Using the previous months accumulated values for the empty parts. Any suggestions?

I use this messure to produce the values from CRM/Dynamics 365:

Accumulated CRM = SUMX(FILTER(ALLSELECTED(OpportunitySet);OpportunitySet[EstimatedCloseDate] <=MAX(OpportunitySet[EstimatedCloseDate]));OpportunitySet[EstimatedValues])

In tha image below I would like to have september accumulated values for october (if empty) and so on.

[v-huizhn-msft]

Hi @Rflad,

Have you resolved your issue? If you have, please mark the helpful reply as answer, or welcome to share your solution. So that more people will find the workaround.

Best Regards,
Angelia

[v-huizhn-msft]

Hi @Rflad,

What do your resource data look like? Why there is "empty" months? I notice you use ALLSELECTED function, is there a slicer in your report? Could you please share more details for further analysis?

Please try the following formula based on your measure, use the new measure and check if it works fine.

New_Accumulated =
IF (
    ISBLANK ( OpportunitySet[Accumulated CRM] ),
    CALCULATE (
        OpportunitySet[Accumulated CRM],
        FILTER (
            OpportunitySet,
            OpportunitySet[EstimatedCloseDate]
                = DATE ( YEAR ( MAX ( OpportunitySet[EstimatedCloseDate] ) ), MONTH ( MAX ( OpportunitySet[EstimatedCloseDate] ) ) - 1, DAY ( MAX ( OpportunitySet[EstimatedCloseDate] ) ) )
        )
    ),
    OpportunitySet[Accumulated CRM]
)

Best Regards,
Angelia