Quick Measure to be adjusted

[Orstenpowers]

Good Morning!

WIth the help of a quick measure I created a YoY% comparison, but unfortunately I am too stupid to adjust this measure in order to get the difference in absolute values instead of relative values.

The measure is as follows:

AmountEUR YoY% =

IF(

    ISFILTERED('Kalender'[Date]),

    ERROR("Quickmeasures mit Zeitintelligenz können nur über die von Power BI bereitgestellte Datumshierarchie oder die primäre Datumsspalte gruppiert oder gefiltert werden."),

    VAR __PREV_YEAR =

        CALCULATE(

            SUM('Data'[AmountEUR]),

            DATEADD('Kalender'[Date].[Date], -1, YEAR)

        )

    RETURN

        DIVIDE(SUM('Data'[AmountEUR]) - __PREV_YEAR, __PREV_YEAR)

)

What do I need to change???

Hopefully someone out there can help me!?

Best regards

Torsten

[FreemanZ]

hi @Orstenpowers 

are you expecting something like this:

AmountEUR YoY% =

IF(

    ISFILTERED('Kalender'[Date]),

    ERROR("Quickmeasures mit Zeitintelligenz können nur über die von Power BI bereitgestellte Datumshierarchie oder die primäre Datumsspalte gruppiert oder gefiltert werden."),

    VAR __PREV_YEAR =

        CALCULATE(

            SUM('Data'[AmountEUR]),

            DATEADD('Kalender'[Date].[Date], -1, YEAR)

        )

    RETURN

        ABS ( DIVIDE(SUM('Data'[AmountEUR]) - __PREV_YEAR, __PREV_YEAR) )

)

[Orstenpowers]

@FreemanZ,

Thanks for your prompt support!

Unfortunately this was not the result I was looking for, but I suppose my request was too vague. 

Taking this screenshot as an example, I need a measure bringing the result € 23.625, so the difference betweeen 2022 and 2021.

Most likely very easy for you...

[FreemanZ · Accepted solution]

hi @Orstenpowers 

aha, then please try:

AmountEUR YoY% =

IF(

    ISFILTERED('Kalender'[Date]),

    ERROR("Quickmeasures mit Zeitintelligenz können nur über die von Power BI bereitgestellte Datumshierarchie oder die primäre Datumsspalte gruppiert oder gefiltert werden."),

    VAR __PREV_YEAR =

        CALCULATE(

            SUM('Data'[AmountEUR]),

            DATEADD('Kalender'[Date].[Date], -1, YEAR)

        )

    RETURN

        SUM('Data'[AmountEUR]) - __PREV_YEAR

)

[Orstenpowers]

@FreemanZ :

PERFECT FIT! Thank you very much!