cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
savanahubio Frequent Visitor
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

 

Costco US- POS Dashboard - Power BI Desktop 2017-11-29 08.14.28.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
sgsukumaran Member
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]))

 

 

savanahubio Frequent Visitor
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 v-caliao-msft
Moderator

Re: YOY - Monthly & Weekly Comparison

@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 Frequent Visitor
Frequent Visitor

Re: YOY - Monthly & Weekly Comparison

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
  • YoY.png
sgsukumaran Member
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]))

 

 

savanahubio Frequent Visitor
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