Forum Discussion
Trend indicator in matrix ccomparing years
- 5 years ago
Trend indicator : =
VAR _startyear =
CALCULATE ( MIN ( 'Calendar'[Year] ), REMOVEFILTERS ( 'Calendar' ) )
VAR _latestyear =
CALCULATE ( MAX ( 'Calendar'[Year] ), REMOVEFILTERS ( 'Calendar' ) )
VAR _currentyear =
MAX ( 'Calendar'[Year] )
VAR _previousyear = _currentyear - 1
VAR _currentyearqty = [Sold Items Total :]
VAR _previousyearqty =
CALCULATE ( [Sold Items Total :], 'Calendar'[Year] = _previousyear )
VAR _comparetoPreviousYear =
IF (
NOT ISBLANK ( _previousyearqty ),
IF ( _currentyearqty >= _previousyearqty, "🔼", "🔽" )
)
VAR _startyearqty =
CALCULATE ( [Sold Items Total :], 'Calendar'[Year] = _startyear )
VAR _latestyearqty =
CALCULATE ( [Sold Items Total :], 'Calendar'[Year] = _latestyear )
VAR _overalltrend =
IF ( _latestyearqty >= _startyearqty, "🔼", "🔽" )
RETURN
IF (
HASONEVALUE ( Items[Item] ),
SWITCH (
TRUE (),
ISINSCOPE ( 'Calendar'[Year] ), _comparetoPreviousYear,
_overalltrend
)
)
Trend indicator : =
VAR _startyear =
CALCULATE ( MIN ( 'Calendar'[Year] ), REMOVEFILTERS ( 'Calendar' ) )
VAR _latestyear =
CALCULATE ( MAX ( 'Calendar'[Year] ), REMOVEFILTERS ( 'Calendar' ) )
VAR _currentyear =
MAX ( 'Calendar'[Year] )
VAR _previousyear = _currentyear - 1
VAR _currentyearqty = [Sold Items Total :]
VAR _previousyearqty =
CALCULATE ( [Sold Items Total :], 'Calendar'[Year] = _previousyear )
VAR _comparetoPreviousYear =
IF (
NOT ISBLANK ( _previousyearqty ),
IF ( _currentyearqty >= _previousyearqty, "🔼", "🔽" )
)
VAR _startyearqty =
CALCULATE ( [Sold Items Total :], 'Calendar'[Year] = _startyear )
VAR _latestyearqty =
CALCULATE ( [Sold Items Total :], 'Calendar'[Year] = _latestyear )
VAR _overalltrend =
IF ( _latestyearqty >= _startyearqty, "🔼", "🔽" )
RETURN
IF (
HASONEVALUE ( Items[Item] ),
SWITCH (
TRUE (),
ISINSCOPE ( 'Calendar'[Year] ), _comparetoPreviousYear,
_overalltrend
)
)