Forum Discussion
Solved
Creating Cumulative Line Chart
I have one data table (named Table) with columns Item, Quantity and Date. I changed the Date column format to "MMMM yyyy" as I want to get the cumulative sum over 12 months in year 2020. Therefore, I...
Hi phth017 ,
Please check the following steps as below.
1. Create a calendar table as below and create 1-* relationship with the fact table.
Table 2 = CALENDAR(DATE(2020,1,1),DATE(2020,12,31))2.Create a measure like this:
Cumulative = CALCULATE(SUM('Table'[value]),filter(ALL('Table 2'),'Table 2'[Date]<=max('Table 2'[Date])))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi phth017 ,
Please check the following steps as below.
1. Create a calendar table as below and create 1-* relationship with the fact table.
Table 2 = CALENDAR(DATE(2020,1,1),DATE(2020,12,31))2.Create a measure like this:
Cumulative = CALCULATE(SUM('Table'[value]),filter(ALL('Table 2'),'Table 2'[Date]<=max('Table 2'[Date])))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the solution! Are there any benefits to using this method rather than a time intelligence function such as TOTALYTD() ?
