If function

Anonymous — Thu, 16 Mar 2023 11:56:21 GMT

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?

Re: If function

Greg_Deckler — Thu, 16 Mar 2023 12:37:21 GMT

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

topic Re: If function in DAX Commands and Tips

If function

Re: If function