I have a meassure which calculates the cumulative sum for booking periods. = CALCULATE ( SUM(data[transaction_amount]); FILTER ( ALL (data[Booking_period]); data[Booking_period] <= MAX (data[Booking_period]))) The numbers are correct but if a booking period does not have data entries for a specific booking period the cells remain bank. Can somebody explain to me what is going on here? And how can I fix it so that instead of empty cells the values from the previous booking period are shown.

Hey Michael-N-N , you are facing the auto-exist problem, that is described in this article. in more detail: Understanding DAX Auto-Exist - SQLBITo solve this issue you have to create a star schema, this article describes the importance of a star schema: Understand star schema and the importance for Power BI - Power BI | Microsoft Learn Here you will find guidance on how to create a date table and how to create running sum measures: Time patterns – DAX Patterns Make sure that you are using the month column from the date table in your visuals, after you created the date table, the relationships, and after adapting your existing measure. Hopefully, this will you to tackle your challenge. Regards, Tom

cumulative sum with empty results | Microsoft Fabric Community

Forum Discussion

Related content

Cumulative Total

Handling Empty Results

Creating Cumulative Graphs

Year to date cumulative

Cumulative Total