Forum Discussion
Solved
Visual calculation measure pattern
Hi,
What would the pattern of a visual calculation measure in a scenario where there is a hierarchy of Year and then Work type in the row labels of a matrix visual. The objective is to know the am...
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.
Thank you for replying. I need to do this using visual calculations (not measures).