how to... Create Measure to identify "direction" of development ofranking from two periods

[thomasreick]

Hello there,

I would like to create a measure to indicate the development of rankings per item from two periods (RankActual=a, RankPrevious=p). Because both values might be <0 or > 0 or = 0, I need a hint how to handle that in a smart way.

My approach seems not good. I did some IF-THEN-ELSE-syntax but the resulting indicator -1 | 0 | +1 is not set correctly

IF ( AND( a<0, p<0 ), a | < | = | > p ) is varying the relations only, but anyway there is a positive development indicated, although not positive logically...

Example: a=-6, p=-4 leads to a < p the delta is (a-p) = -2, the movement is 2 points DOWN., but it is shown as upward-movement.

Actually I am stuck on this and kindly request your input.

thank you very much

Thomas

[Anonymous]

Hi,

In this case use abs(a)-abs(p) it should give +2

[v-yinliw-msft]

Hi @thomasreick ,

I think you want if a < p, it should be down and if a > = p, it should be up?

May be you can try: IF( a < p, p - a, a - p)

What do you mean "it is shown as upward-movement"?

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[thomasreick]

Hello v-yinliw-msft,

thx for your input. I will give it a try.

Upward movement means, that I want to indicate for readability the direction of development with a unichar-character to show the direction also for negative ranks.

According to above example a=-6, p=-4 is a negative development of -2, the direction should be indictated with unichar(11167), an arrow pointing down in a separate field