SUMX This Year (Leap Year) vs Last Year (Not a Leap Year) that match exactly Day of Weeks

[Hystericred]

Im trying to do it like this :

Total Revenue LY for 2020 (Net Amount):=
                   CALCULATE([Total Revenue (Net Amount)],
                              DATEADD('dRollingCalendar_2018 to Now'[date],-364,DAY
                                )
                    )
But the result doesn't seems to match DOW , pls helps : (

[v-gizhi-msft]

Hi,

If my answer has solved your issue, please mark it as a solution for others to see.
Thanks!

Best Regards,

Giotto

[v-gizhi-msft · Accepted solution]

Hi,

You can try this measure(without other calender table):

Total Revenue LY for 2020 (Net Amount) =
CALCULATE (
    [Total Revenue (Net Amount)],
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Date]
            = DATE ( YEAR ( MAX ( 'Table'[Date] ) ) - 1, MONTH ( MAX ( 'Table'[Date] ) ), DAY ( MAX ( 'Table'[Date] ) ) )
    )
)

Hope this helps.

If you still have any issue, please share some sample data and expected result as screenshots here.

Thanks!

Best Regards,

Giotto 

[amitchandak]

@Hystericred 

This one seems correct. The same weekday is always 364 days behind. But the same day would be 1 year behind

Total Revenue LY for 2020 (Net Amount) same Week day:=
CALCULATE([Total Revenue (Net Amount)],
DATEADD('dRollingCalendar_2018 to Now'[date],-364,DAY
)
)

Total Revenue LY for 2020 (Net Amount) Same day:=
CALCULATE([Total Revenue (Net Amount)],
DATEADD('dRollingCalendar_2018 to Now'[date],-1,Year
)
)