Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

If function

Hi, 

 

I have created this measure

 

Arrow R12 Rank = if([Rolling 12 Difference Rank]>0,"↑",if([Rolling 12 Difference Rank]=0,"-","↓"))
 
The rolling 12 difference is -1 but when I am putting the formula in a card I am getting "-", as the formula is recognising the answer as 0.
 
Rolling 12 Difference Rank = [Rolling 12 PY Rank] - [Rolling 12 Rank]
 
Rolling 12 Rank = RANKX(ALL(Client[Clients]),VALUE(Financials[Premium]))
Rolling 12 PY Rank = RANKX(ALL(Client[Clients]),VALUE(Financials[ PY Premium]))
 
 Rolling 12 rank = 22
Rolling 12 PY rank = 21
 
 
Any ideas why?
 
 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous Try:

    Arrow R12 Rank = 
  VAR __RollingDiff = [Rolling 12 Difference Rank]
  VAR __Result = 
    SWITCH(TRUE(),
     [Rolling 12 Difference Rank] > 0,"↑",
     [Rolling 12 Difference Rank] < 0,"↓",
     "-"
    )
RETURN
  __Result