cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## YOY - Monthly & Weekly Comparison

Here is what I need - for both Monthly & Weekly view. My data source is line item data so I am able to get the YoY comparison

2 ACCEPTED SOLUTIONS

Accepted Solutions
Member

## Re: YOY - Monthly & Weekly Comparison

You can try creating a calculated column

LY Sales = CALCULATE([Total Sales], DATEADD(Orders[Order Date],-1,YEAR))

or

LY Sales = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Orders'[Order Date]))

Frequent Visitor

## Re: YOY - Monthly & Weekly Comparison

I found a way to get the results I needed.

I created 2 columns

2016 Dollar Sales =IF(Daily Sales Date Year = 2016, Dollar Sales)

2017 Dollar Sales =IF(Daily Sales Date Year = 2016, Dollar Sales)

Use Quick Measure - Percentage Difference.

Used 2016 Dollar Sales! It worked! I did this for Dollar Sales & Unit Sales

4 REPLIES 4
Moderator

Regards,
Charlie Liao

Frequent Visitor

## Re: YOY - Monthly & Weekly Comparison

Hello Charlie,

This is what I want for both Unit Sales & Dollar Sales.

• YoY % by Month for 2016 & 2017
• YoY % by Week for 2016 & 2017
Member

## Re: YOY - Monthly & Weekly Comparison

You can try creating a calculated column

LY Sales = CALCULATE([Total Sales], DATEADD(Orders[Order Date],-1,YEAR))

or

LY Sales = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Orders'[Order Date]))

Frequent Visitor

## Re: YOY - Monthly & Weekly Comparison

I found a way to get the results I needed.

I created 2 columns

2016 Dollar Sales =IF(Daily Sales Date Year = 2016, Dollar Sales)

2017 Dollar Sales =IF(Daily Sales Date Year = 2016, Dollar Sales)

Use Quick Measure - Percentage Difference.

Used 2016 Dollar Sales! It worked! I did this for Dollar Sales & Unit Sales