Forum Discussion

bideveloper555's avatar
bideveloper555
Icon for Helper IV rankHelper 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
Icon for Helper IV rankHelper IV
4 years ago

👏👏👏

That was one hell of measure.

thank again for all the hard work.

working like a beauty.

 

one small issue i have noticed.

if user selects multiple months, if any stores has sales in 2 months, that store is elimintaed in measure.

 

when jan 2021 was selected.

 

when jan & Feb 2021 was selected.

 

tbh, that was impressive the work you have done.

GREAT JOB ICEY

 

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
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.