Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
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:
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
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:
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 38 | |
| 20 | |
| 17 |
| User | Count |
|---|---|
| 68 | |
| 65 | |
| 30 | |
| 26 | |
| 25 |