MoM

[netanel]

Hey All!

I have this measure:

MoM =

VAR __BASELINE_VALUE = [Last Month AVG Net]

VAR __VALUE_TO_COMPARE = [Net USD AVG]

RETURN

IF(

NOT ISBLANK(__VALUE_TO_COMPARE),

DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

) & IF([????????] >0, "⇧","⇩")

I added to the Measure what is marked in red
My problem is
I want that  if the measure will be negative  so a down arrow, and if is positive arrow in green
1. What to put inside the question marks? (in blue)
2. How to arrange the colors?

Thank you!

[goncalogeraldes]

Hello there @netanel ! You can try this:

MoM = 
VAR __BASELINE_VALUE = [Last Month AVG Net]
VAR __VALUE_TO_COMPARE = [Net USD AVG]
VAR __CONDITION =
    IF (
        NOT ISBLANK ( __VALUE_TO_COMPARE ),
        DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE )
    )
RETURN
    SWITCH ( TRUE (), __CONDITION > 0, UNICHAR ( 9650 ), UNICHAR ( 128315 ) )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[netanel]

Hey @goncalogeraldes 

I stick to this solution
I just put card on card and that's how I got my formula that it's good and your arrow.
The problem is that sometimes even though the negative result the sign is positive
Can understand why?

[netanel]

@goncalogeraldes 

you can look on that please?

[goncalogeraldes · Accepted solution]

MoM = 
VAR __BASELINE_VALUE = [Last Month AVG Net]
VAR __VALUE_TO_COMPARE = [Net USD AVG]
VAR __CONDITION =
    SWITCH (
        TRUE (),
        NOT ISBLANK ( __VALUE_TO_COMPARE ),
            FORMAT (
                DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE, 0 ),
                "0.0%"
            )
    )
VAR __CONDITION_UNFORMATTED =
    SWITCH (
        TRUE (),
        NOT ISBLANK ( __VALUE_TO_COMPARE ),
        DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE, 0 )
    )
RETURN
    SWITCH (
        TRUE (),
        VALUE ( __CONDITION_UNFORMATTED ) >= 0, CONCATENATE ( __CONDITION, CONCATENATE ( " ", UNICHAR ( 9650 ) ) ),
        CONCATENATE ( __CONDITION, CONCATENATE ( " ", UNICHAR ( 128315 ) ) )
    )

with this measure I get the correct classification, it has to be something in your data.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[netanel]

Hey @goncalogeraldes 

Thanks for the quick respons!

Something is wrong
1. Instead of bringing me a number and the arrow next to it  only brings me the arrow
2. The condition is right the arrow goes up and down in the right places, but instead of green I get black color and another arrow

In the card above your formula
In the card below my formula
Attaches a photo

Thank you!

[goncalogeraldes]

Hello there @netanel ! I thought you only wanted the arrow. Try this then:

MoM =
VAR __BASELINE_VALUE = [Last Month AVG Net]
VAR __VALUE_TO_COMPARE = [Net USD AVG]
VAR __CONDITION =
    IF (
        NOT ISBLANK ( __VALUE_TO_COMPARE ),
        DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE )
    )
RETURN
    SWITCH (
        TRUE (),
        __CONDITION > 0,
            __CONDITION && " "
                && UNICHAR ( 9650 ),
        __CONDITION && " "
            && UNICHAR ( 128315 )
    )

You can further customize to your needs 🙂

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[netanel]

@goncalogeraldes 

I GET THAT

[goncalogeraldes]

As far as my understanding goes, you can do it like this:

MoM =
VAR __BASELINE_VALUE = [Last Month AVG Net]
VAR __VALUE_TO_COMPARE = [Net USD AVG]
VAR __CONDITION =
    SWITCH (
        TRUE (),
        NOT ISBLANK ( __VALUE_TO_COMPARE ), DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE, 0 )
    )
RETURN
    SWITCH (
        TRUE (),
        __CONDITION > 0, CONCATENATE ( __CONDITION, CONCATENATE ( " ", UNICHAR ( 9650 ) ) ),
        CONCATENATE ( __CONDITION, CONCATENATE ( " ", UNICHAR ( 128315 ) ) )
    )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[netanel]

@goncalogeraldes 

Something just does not work out
In the card above it is not possible to change to percentages
That's weird
It is defined on text
And in general again the result of the positive comes in a different arrow and in black
And even the numbers are different

Anyway thanks I will try to check with my data what the problem is

[goncalogeraldes]

@netanel  try this:

MoM 2 =
VAR __BASELINE_VALUE = [Last Month AVG Net]
VAR __VALUE_TO_COMPARE = [Net USD AVG]
VAR __CONDITION =
    SWITCH (
        TRUE (),
        NOT ISBLANK ( __VALUE_TO_COMPARE ),
            FORMAT (
                DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE, 0 ),
                "0.00"
            )
    )
RETURN
    SWITCH (
        TRUE (),
        VALUE ( __CONDITION ) > 3, CONCATENATE ( __CONDITION, CONCATENATE ( " ", UNICHAR ( 9650 ) ) ),
        CONCATENATE ( __CONDITION, CONCATENATE ( " ", UNICHAR ( 128315 ) ) )
    )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[netanel]

@goncalogeraldes 

Still not getting the right result
I really do not understand what the problem is ...
It should be simple
I used to do something like this:
Measure = IF ([sum]> = 0, [sum] & "⇧", [sum] & "⇩")
But nothing works out for me ...

This is what came out of your last formula:

[goncalogeraldes]

@netanel Why dont you use conditional formating with icons then? To show as percentage do the following:

MoM =
VAR __BASELINE_VALUE = [Last Month AVG Net]
VAR __VALUE_TO_COMPARE = [Net USD AVG]
VAR __CONDITION =
    SWITCH (
        TRUE (),
        NOT ISBLANK ( __VALUE_TO_COMPARE ),
            FORMAT (
                DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE, 0 ),
                "0.0%"
            )
    )
RETURN
    SWITCH (
        TRUE (),
        VALUE ( __CONDITION ) > 0, CONCATENATE ( __CONDITION, CONCATENATE ( " ", UNICHAR ( 9650 ) ) ),
        CONCATENATE ( __CONDITION, CONCATENATE ( " ", UNICHAR ( 128315 ) ) )
    )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes