Forum Discussion

bideveloper555's avatar
bideveloper555
Helper IV
4 years ago
Solved

YOY Measure with Filter

https://drive.google.com/file/d/1sXxowxdHFdSkUAI5z8vM8Bw48Lj6O20u/view?usp=sharing  hi please find the attached sample. am working on dash board. Criteria for dashboard: IF in current month or p...
Need Help
Show and Tell
Tips and Tricks
  • Icey's avatar
    Icey
    4 years ago

    Hi bideveloper555 ,

     

    Something like this?

     

    TurnoverAmount MoM% =
VAR _Cur_Pre =
    SUMX (
        VALUES ( 'Table'[shopid] ),
        IF (
            [_Cur_TurnoverAmount MoM%] * [_Pre_TurnoverAmount MoM%] <> 0,
            [_Cur_TurnoverAmount MoM%] - [_Pre_TurnoverAmount MoM%]
        )
    )
VAR _Pre =
    SUMX (
        VALUES ( 'Table'[shopid] ),
        IF (
            [_Cur_TurnoverAmount MoM%] * [_Pre_TurnoverAmount MoM%] <> 0,
            [_Pre_TurnoverAmount MoM%]
        )
    )
RETURN
    DIVIDE ( _Cur_Pre, _Pre )

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bideveloper555's avatar
bideveloper555
Helper IV
4 years ago

hi guys,

any help.

YOY on a card,but store sales should be excluded if previous year or current no sales.

only YOY need to calculate for those store which has both side values.