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.

     

     

v-sdhruv's avatar
v-sdhruv
Icon for Community Support rankCommunity Support
1 year ago

Hi grasa ,

This might be because" January 2025 has no corresponding January 2024 data in your dataset." as earlier stated by jaineshp 
As per the measure, it will show blank()  but you can modify the measure by using:

Diff % LY Modified =
IF (
    YEAR ( MAX ( 'DateTable'[Date] ) ) <> 2025,
    BLANK(),
    IF (
        ISBLANK ( [Gesamtmenge] ) || ISBLANK ( [LY Menge] ),
        BLANK(),
        DIVIDE ( [Gesamtmenge] - [LY Menge], [LY Menge] )
    )
)

This ensures the measure only returns values for 2025
Hope this helps!

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

Hi v-sdhruv ,

Thank you very much for your reply and your suggestion. Unfortunately it does the same as the other ones. It shows blanks for the missing values but still shows up in the 2024 column.