Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

DAX Measure comparing Day of Year to same Day LY

How do i compare sales $ for the same day last year?

I want to compare Sales $ for Day 1 2022 (1/29/2022) vs Day 1 2023 (2/4/2023).

Currently it is being compared to Day 8 2022 (2/5/2022)

I'd also like it to be on going in order to capture WTD, MTD & YTD.

Below are 2 different visuals in order to capture the data i would like to compare so far this year.


Day of the year.PNG




Helpful resources

Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors