Data accumulation / by Quarter with categories

Lalü 

I guess for 2023 Qtr 1 and 2025 Qtr 4 there is no data in your fact table. Even in this scenario, as per the cumilative logic, data should be displayed in those quarters. I believe there is an issue with your dax forumla.

While writing DAX expressions never filter table, always filter columns. May be modify your dax expressions a bit and filter the columns not tables.

Just to a give you a very simple exmple, I have taken a data sample with discrete dates (fact table)

Created a date table with continuous dates with no missing dates in between (make sure your date table does not have any missing dates in between)

I joined these tables by creating a one to many relation. 

I created a simple dax measure like this 

Cumulative = 
Var __Date = MAX(DateTable[Date])
Var __Result = CALCULATE(SUM('DataTable'[Value]), DateTable[Date] <= __Date, REMOVEFILTERS(DateTable))
RETURN __Result 

and placed it in y axis of a line chart and then placed quarter column in x axis of a line chart  

Hope this helps

Connect on LinkedIn

Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!