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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Not applicable

Week over Week and comparison this year week to last year week

Hello Everyone


Please help!


I am starting my first PBI project.

But there are some problems.🤔😑


My customers want TABLES with


1. Sales by Week over Week and difference % comparison too /week comparing last week/


2. This year Week sales comparing Last year week sales and difference % as well. /2019.01st week comparing 2018.01st week.../


Are there any methods to show like that? Or it isnt possible to show like that in Power BI?🤔😐🙄😃






Not applicable

Hi @Anonymous 


Because there is no sample data I will try to describe the approach I would take.


Here I"m assuming your client wants everything in Table "Matrix"


Sales Week Over Week :


Make New Column of Week Num


WeekNum = WEEKNUM(Table-Date)


Now use this column with revenue/sales data to show sales by week. 

Please make sure to change Value -Sales to sum.


2. Calculate Same period last year


VAR DataMaxDate =
CALCULATE ( MAX ( 'GenIQ'[Date.Date].[Date] ), ALL ('GenIQ' ) )
VALUES ( 'GenIQ'[Date.Date].[Date] ),
DATESBETWEEN ( 'GenIQ'[Date.Date], BLANK (), DataMaxDate )




Gaurav Raj Singh


If you need more help,

Contact with me on linkedIN :



Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors