Forum Discussion
Running sum
Hello, Im hoping someone can help, How can I get this measure to leave the running total for the rest of the month blank if there is nothing in the ytd corresponding column, at the moment it fills in the rest of the days with what it has calculated so far.
I think you can get this by just updating your visual calc like so:
Running sum = IF( NOT ISBLANK( [YTD] ), RUNNINGSUM([YTD]) )
8 Replies
I think you can get this by just updating your visual calc like so:
Running sum = IF( NOT ISBLANK( [YTD] ), RUNNINGSUM([YTD]) )This worked like a dream, thank you !
Do you want to handle it in Excel, Power Query or Dax?
Hi Julier,
Thank you for providing information on your issue. I’ve reviewed your scenario and successfully replicated it using sample data on my end.
I’m sharing the working .pbix file below so you can explore the setup and DAX logic more clearly. Please feel free to open it and review how the relationships and measures are configured:
I hope this helps resolve your issue. If you have any questions or need further clarification, I’m happy to help.
Thanks for being part of the Microsoft Community!
Thank you for your reply unfortunately I need to be able to graph as below and as the data behind it has different sites attched to the sales I also need the graph to change when a slicer is selected, as you can see the chart flatlines at the last running total due to no sales from day 3 forward as yet, I want the current year line to grow as the month goes on
