This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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:
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 23 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 64 | |
| 41 | |
| 28 | |
| 22 | |
| 22 |