how to do cumulative total

[rehman1]

Hello, 

i have a data set in which i want to have a cumulative total of "Totalofcurrentdata" in column "Cumulativetotalofcurrentdata". how can i acheive this in PBI. here is what it should look like in PBI. ( i just need to know how to create the column "Cumulativeofcurretndata" as shown in example below

Month	HistoricData	CurrentData	TotalofCurrentData	Cumulativetoalofcurrentdata(?)
Null	2	null	0	0
jan	3	4	8	=0+8=8
feb	4	5	9	=8+9=17
mar	5	6	11	=17+11=28
april	6	7	13	=28+13=41

please help before i go insane

Thanks

[v-chuncz-msft]

@rehman1 

By the way, you may research Quick measure Running total.

[nandukrishnavs]

@rehman1 

You have to include a date column.

refer to this https://www.sqlbi.com/articles/computing-running-totals-in-dax/

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[rehman1]

Thanks for your reply but i cant use date function. it has to be text as shown in my example above

[Anonymous · Accepted solution]

@rehman1 

make sure your underlying data is in the date format. if thats not possible, use a SWITCH statement to add a date column to your table, and use the running total sum feature on that field instead.

You then need to add the field with the "mmm" date format to your table.