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

        FreemanZ :

        PERFECT FIT! Thank you very much!