Cumulative view in Custom column

[Anonymous]

Hi all,

I wanted to know if there's a way to show cumulative values via"Custom column" not DAX.

I later have to unpivot the columns, hence DAX is of no use here.

Thank you.

Best Regards,

Adarsh 

[amitchandak]

@Anonymous , a new column using something like this

sumx(filter(Table, Table[index] <=earlier(Table[index])), Table[Value])

index or incremental date or datetime

[Anonymous]

Thanks, Amit!

I've been really struggling to build the following view:

I've two columns:

1. Confirmed date

2. Completed date

a. I want to show the count of dates per week(here the month would also do) for the confirmed date. - Grey Line

b. Cumulative of confirmed date (Dotted green) & Cumulative of completed date (Green)

c. We can ignore the blue line

Exel table is in the below format:

Any help is much appreciated. 

Thank you

[v-shex-msft · Accepted solution]

HI @Anonymous,

If you want to analyze records across multiple date fields, you can take a look at the following link(Greg shared some common scenarios) 'start date', 'end date' part if it helps:

Before You Post, Read This 
Regards,

Xiaoxin Sheng