Forum Discussion
Running totals
Hi All,
Sorry if am wrong but i could manage to get the result as with Earlier Function.
Thank you all for your time.
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,
Community Supporthi, 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
Hi All,
Sorry if am wrong but i could manage to get the result as with Earlier Function.
Thank you all for your time.