Calculating 3 Month rolling total not working when value is blank

[Wagwo0rd4powerb]

Example of my code:

Oct2023 is blank and therefore no value displays. Please advise.

[Wagwo0rd4powerb]

still not working ☹️

[Anonymous]

Hi @Wagwo0rd4powerb ,

Try replacing blank with 0. via power query if the connection mode supports it.

Best regards,
Community Support Team_ Scott Chang

[Wagwo0rd4powerb]

This also does not work... 

3 Months CaseCounQTY Rolling Total = CALCULATE(SUM(MDSProduction[Amount Case Count])+0,
DATESINPERIOD(MDSProduction[Month Year Date],LASTDATE(MDSProduction[Month Year Date]),-3,MONTH)) 

[Anonymous]

Hi @Wagwo0rd4powerb ,

Try using the following expression:

3MonthRollingTotal = 
CALCULATE(
    SUMX(
        Table,
        IF(ISBLANK(Table[Value]), 0, Table[Value])
    ),
    DATESINPERIOD(
        Table[Date],
        LASTDATE(Table[Date]),
        -3,
        MONTH
    )
)

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.