Cumulative Area Plot based on cumulative weekly occurrences of dates

[holydragon]

Hi, 

I find this is very simple to do in Excel but I've been having a problem getting it to work in power BI.

I have a column showing the date of occurrence of an event.

Event	Result
1/1/2020	1
3/4/2020	3
3/5/2020	4
2/2/2020	2

What I would like to show is a cumulative area plot.  Each event occurence only counts as a single point for the cumulative sum.

I would like the cumulative sum to be based on the week and not the day.  In the end, we should see an area plot as follows..

Week	Count
1	1
2	1
3	2
4	2
5	3
6	3
7	4

Note: the above table does not reflect what is expected from the example data provided.  It merely shows that if I have a week with no events the cumulative total would reflect the value from the previous week.

Any help that you can provide would be greatly appreciated.

HD

[Greg_Deckler]

@holydragon - Please @ me or mark this as an answer if this solved your problem.

[Greg_Deckler]

@holydragon - Probably something like the following:

Column =
  VAR __Table = 
    SUMMARIZE(
      ADDCOLUMNS(
        FILTER('Table',[Event] < EARLIER([Event]),
        "Week",
        WEEKNUM([Event])
      ),
      [Week]
    )
RETURN
  COUNTROWS(__Table)