Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
savanahubio
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

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

 

 

View solution in original post

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

View solution in original post

4 REPLIES 4
v-caliao-msft
Employee
Employee

@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

 

 

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

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

 

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.