Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |