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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
finzilla
Frequent Visitor

Daily This Week vs Last Week

Good day...  Fairly new to PBI so please bare with me.... I have a client who looks at their business from a daily perspective from a this week versus last week view. I've been fighting with this for a couple of weeks now, and frustration has set in.

 

Here is a sample of the output they are looking for. I've got a date table, and a dateperiod table with Weeknumber, and a bunch of other period columns:

 

store week sales2.png

 

 

 

 

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

OK, so what is the issue? Can you provide example source data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

I guess the core problem is that the data is stored transaction by transaction (see below). So, my questions are:

 

1. Should I create a table that dynamically summarizes the data to daily entries when updating?

2. How to get the daily summaries into a daily this week / last week like the format above? 

 

Here is a sample of the sales transactions file from two perspectives:

 

salesfile1.pngsalesfile2.png

 

 

 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.