Forum Discussion

Orstenpowers's avatar
Orstenpowers
Post Patron
3 years ago
Solved

Quick Measure to be adjusted

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
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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
    )

4 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    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's avatar
      Orstenpowers
      Post Patron
      3 years ago

      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's avatar
        FreemanZ
        Super User
        3 years ago

        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
        )