Forum Discussion

Wagwo0rd4powerb's avatar
Wagwo0rd4powerb
Regular Visitor
2 years ago

Calculating 3 Month rolling total not working when value is blank

Example of my code:   Oct2023 is blank and therefore no value displays. Please advise.
Need Help
Wagwo0rd4powerb's avatar
Wagwo0rd4powerb
Regular Visitor
2 years ago

still not working ☹️

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Wagwo0rd4powerb ,

     

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

     

    Best regards,
    Community Support Team_ Scott Chang