Forum Discussion
cumulative sum with empty results
Hey Michael-N-N ,
you are facing the auto-exist problem, that is described in this article. in more detail: Understanding DAX Auto-Exist - SQLBI
To 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 LearnHere 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
Hey Michael-N-N ,
you are facing the auto-exist problem, that is described in this article. in more detail: Understanding DAX Auto-Exist - SQLBI
To 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