Running totals

[Anonymous]

Hi,

For the atached Data please help me with the Running total in a Calcualted Column.

Can we apply Running totals (Calcualted Column) to an existing  Calcualted Column in the dataSet.?

Regards,

https://drive.google.com/file/d/18gOG1b4VIlnQyg-c-xXQf9K7VcsPrCO2/view?usp=sharing

[Ashish_Mathur]

Hi,

What is the logic of the numbers in the Required result column?  Why does the cell link change in cell E7?  Describe the question in detail.  Describe the business logic.

[Anonymous]

Hello Ashish,

I'll make clear about my requirement. wish to roll the numbers till the end of financial Year and get the result.

Example: I 've a REvenue figure ($500) expected in August'19 (Monthly Recurring) should be added to the revenue till FY 20 (Till Mar'20) . Hence, $500* 8 = $4000 and this should be added to my total forecasted Revenue. 

Please help me with the request.'ve below data sets.

1. Datasets with revenue figures month 

2. Master Calender data set with month as primary Column between both.

Please advise the logic we can roll the numbers till the end of financial year from the time month it is expected.

Please let me know if you need further details.

Regards,

[v-lili6-msft]

hi, @Anonymous 

I'm a little confused by your description, Why your Required Result from E2:E5 is D column and from E6:E13 is column? It seems that it has nothing to do with what you said above.

what is your logic?

and for calculate column of running total, you may try EARLIER Function in it.

https://powerpivotpro.com/2012/03/the-correct-usage-of-earlier/

https://exceleratorbi.com.au/earlier-vs-earliest-dax/

Best Regards,

Lin

[Anonymous · Accepted solution]

Hi All,

Sorry if am wrong but i could manage to get the result as with Earlier Function.

Thank you all for your time.

[Ashish_Mathur]

Hi,

I have read your question over and over again.  I just cannot understand.  May be someone else will help you.