topic how to... Create Measure to identify "direction" of development ofranking from two periods in DAX Commands and Tips

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

thomasreick — Thu, 13 Oct 2022 14:08:59 GMT

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

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

Anonymous — Thu, 13 Oct 2022 14:18:37 GMT

Hi,

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

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

v-yinliw-msft — Fri, 14 Oct 2022 09:29:07 GMT

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.

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

thomasreick — Fri, 14 Oct 2022 10:12:36 GMT

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