Forum Discussion

FP68's avatar
FP68
Icon for Helper I rankHelper I
5 months ago

How to add an indicator

Hello, I’m trying to set an indicator on a Matrix. It is composed from a History table that has a column with the name of a site (JV), a month (Month) and a volume (VolumeGo) So i have one line pe...
Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
5 months ago

Add Month Offset calculated column:

Month Offset = DATEDIFF(TODAY(), History[Month], MONTH)

Measure for indicator:

  
Trend Indicator = 
VAR CurrentVol = [VolumeGo]
VAR PrevVol = 
CALCULATE(
[VolumeGo],
FILTER(History, History[Month Offset] = MAX(History[Month Offset]) + 1)
)
RETURN 
IF(CurrentVol > PrevVol, "↑", IF(CurrentVol < PrevVol, "↓", "→"))