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
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
Super User
Super User

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


@ 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!:
Mastering Power BI 2nd Edition

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
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.