YOY - Monthly & Weekly Comparison

[savanahubio]

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

[sgsukumaran · Accepted solution]

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]))

[v-caliao-msft]

@savanahubio,

It's hard to understand your requirement based on your description. Please provide us more information about your report, so that we can make further analysis. You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.

Regards,
Charlie Liao

[savanahubio]

Hello Charlie,

Here is a link to my file. https://drive.google.com/open?id=1Ivhtgj5F9Xw5J0nqIZkMbvWz3yeu4mr6

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

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

[sgsukumaran · Accepted solution]

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]))

[savanahubio · Accepted solution]

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