Forum Discussion
Evolution Index On Matrix Visual
Hello Everyone, I have data of 2018 2019 2020 . I would like to see EVOLUTION INDEX of (2019 and 2020) on matrix visual, using (EINDEX = DIVIDE(1 + [Growth YOY],CALCULATE( 1 + [Growth YOY],ALLSELE...
vytautas1410 Indeed, it requires a glance of data model to troubleshoot. Btw, I think in such expressions, ALL('Calendar'[Date]) is redundant.
VAR __PREV_YEAR = CALCULATE(SUM('M'[Value]), ALL('Calendar'[Date]) , DATEADD('Calendar'[Date].[Date], -1, YEAR))
VAR __THIS_YEAR = CALCULATE(SUM('M'[Value]),ALL('Calendar'[Date]) ,DATEADD('Calendar'[Date].[Date], 0, YEAR))When the first parameter of DATEADD func references a date column, it's replaced by CALCULATETABLE ( DISTINCT ( <Dates> ) ); context transition applies and filter context also takes effect accordingly. DATEADD returns a date table after the call, which is surely a subset of ALL(Calendar[Date]).