Forum Discussion
Solved
Cumulative sum by dates (Even the missing dates)
Hi, I am using measure to calculate profit across the dates. This is the data that I am using. Date, Revenue on that date and Cumulative revenue. Cumulative value even when I choose a part...
Hi shubh25 ,
One sample for your reference, please check the following steps as below.
1. Create a calendar table as below and make it related to the fact table.
CALENDAR = CALENDAR(DATE(2019,01,01),DATE(2019,01,31))
2. To create a measure.
Measure = CALCULATE(SUM('Table'[Revenue]),FILTER(ALL('CALENDAR'),'CALENDAR'[Date]<=MAX('CALENDAR'[Date])))
Hi,
What is the difference between the 3rd and 4th Table?