Forum Discussion

grasa's avatar
grasa
Icon for Helper I rankHelper I
1 year ago
Solved

Show Diff PY just once

Dear all,   I would like to show a qty vs. previous year qty comparison. Therefore I already created a measure which calculates the % diff to last year. Do you have any idea how I could remove the ...
Need Help
  • grasa's avatar
    grasa
    1 year ago

    v-sdhruv Many thanks for your feedback! 

    Now I put a white square over the text to hide the headline "Diff % LY" for 2024. Probably not the best solution but I couldn´t find another one 😉 . 

    Thanks again for all the help.

     

     

grasa's avatar
grasa
Icon for Helper I rankHelper I
1 year ago

FBergamaschi , jaineshp Thank you very much for your fast reply on this. Unfortunately none of the new measures solved my problem.

 

 

 

Here is my measure for the Diff % LY calculation, maybe this helps:

Gesamtmenge = Total Qty

Menge = Qty

 

Thanks again and best regards,

Sarah

 

 

  • jaineshp's avatar
    jaineshp
    Icon for Memorable Member rankMemorable Member
    1 year ago

    Hey grasa,

    Key Points:

    • The issue occurs because Januar 2025 has no corresponding Januar 2024 data in your dataset
    • Your original measure works fine when both current and previous year data exist
    • These solutions handle the missing previous year data scenario
    • Choose Option 1 if you want blanks, Option 2 for zeros, or Option 3 for custom text

    Try this:

     

    Diff % LY Modified =
    IF(
    ISBLANK([LY Menge]),
    BLANK(),
    DIVIDE([Gesamtmenge] - [LY Menge], [LY Menge])
    )

     

    Fixed? ✓ Mark it • Share it • Help others!


    Best Regards,
    Jainesh Poojara | Power BI Developer

    • grasa's avatar
      grasa
      Icon for Helper I rankHelper I
      1 year ago

      jaineshp 

      Many thanks again! Indeed I have missing data, but for 2025.

       

      If I use your measure but use "Gesamtmenge" instead of "LY Menge", the -100% for the missing data dissapears (that is also really nice to have, thanks 😊), but the empty Diff % LY column for 2024 still stays there.

       

       

       

      • jaineshp's avatar
        jaineshp
        Icon for Memorable Member rankMemorable Member
        1 year ago

        Hey grasa,

        Diff % LY Modified =
        IF(
        ISBLANK([Gesamtmenge]) || ISBLANK([LY Menge]),
        BLANK(),
        DIVIDE([Gesamtmenge] - [LY Menge], [LY Menge])
        )


        Try this.