Visual calculation measure pattern

Hi Ashish_Mathur ,

Still working out the use case for the visual calculations but since it's based on the line values and is not like excel exactly I have created the following calculations:

Previous Year (support) = NEXT([Year]) 

Previous Year = IF([Previous Year (support)] = [Year],NEXT( [Previous Year (support)]), [Previous Year (support)])

Value = 
IF(
   ISINSCOPE([Work]),
      LOOKUP([Sum of Amoount], [Work], [Work], [Year], [Previous Year]) , 
      LOOKUP([Sum of Amoount], [Year], [Previous Year])
 )

Then hide the Previous Year columns

Hope this helps you get started, has I said still trying some things and we can do more complex calculations for sure but this simple approach works.