Forum Discussion

kpct56591's avatar
kpct56591
Frequent Visitor
1 year ago
Solved

Difference between two years showing under both years

Hello,   I am trying to have a matrix that displays the YOY difference in quantity shipped. I have a measure that does that, but it displays under both years. How can I remove it from 2023? ...
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi kpct56591 ,

    Try out this below measure

    ShipQtyDiffFrom2023 =
    VAR ThisYear = SELECTEDVALUE('ofrordx'[Ship Date].[Year])
    VAR CurrentQty = SUM('ofrordx'[Ship Qty])
    VAR BaseQty2023 =
    CALCULATE(
    SUM('ofrordx'[Ship Qty]),
    'ofrordx'[Ship Date].[Year] = 2023
    )
    RETURN
    IF(
    ThisYear > 2023 &&
    NOT ISBLANK(BaseQty2023) &&
    NOT ISBLANK(CurrentQty),
    CurrentQty - BaseQty2023
    )

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

Hi kpct56591 ,

May I ask if you have gotten this issue resolved?

 

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,
Chaithra.