Forum Discussion

SaiJ301120's avatar
SaiJ301120
Frequent Visitor
3 years ago
Solved

Displaying Change Indicators

I Have a requirement to show the previous month value and previous of previous month value in individually and betwwen these two to have an arrow indication if the present month value has increased,d...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi SaiJ301120 

    something like this?

     

    Indicator = 
VAR _valuecurrent = SUM(TableName[Projects Delivered])
VAR _valuecurrentlm = 
SUMX(
    FILTER(
        ALL(TableName),
        TableName[Date]=EDATE(MAX(TableName[Date]), -1)
    ),
    TableName[Projects Delivered]
)
VAR _diff = _valuecurrent - _valuecurrentlm
RETURN
IF( _diff>=0, UNICHAR(9650), UNICHAR(9660))

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi SaiJ301120 

something like this?

 

Indicator = 
VAR _valuecurrent = SUM(TableName[Projects Delivered])
VAR _valuecurrentlm = 
SUMX(
    FILTER(
        ALL(TableName),
        TableName[Date]=EDATE(MAX(TableName[Date]), -1)
    ),
    TableName[Projects Delivered]
)
VAR _diff = _valuecurrent - _valuecurrentlm
RETURN
IF( _diff>=0, UNICHAR(9650), UNICHAR(9660))

 

SaiJ301120's avatar
SaiJ301120
Frequent Visitor
3 years ago

This can work but i want to display only the last two months that too in a format like two individual visuals for the previous and previous of previous (Just those two) and and an indicator for which i suppose we can use a card with unichar values for indications .

 

one like the picture i have provided in the doubt above 

 

 

Thanks for all the Effort .