Forum Discussion
Help with estimating
Hello I have a simple file which is based on a regulatory returns a company submits to a regulatory body. The company submits this file at the end of each financial year and the revenue amongst ...
Anonymous
I create a sample with blank revenue for FY19/20. You need to create an Index Column to get the revenue from previous row (previews FY) as Est Revenue.
BTW, I am not sure if this is your requirement, but it is not possible to add a row from no where in to the current table, you need to have the Company or FY in the first place.
Est Revenue = IF('Table'[Revenue]=BLANK(),CALCULATE(SUM('Table'[Revenue]),FILTER('Table',[Index]=EARLIER('Table'[Index])-1),ALLEXCEPT('Table','Table'[Company])))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.