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

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.

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

    Hi jaineshp ,

    Many thanks for your help, unfortunately it is still showing the one for 2024.