Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
We run our reporting weeks from Saturday to Friday. I need to create things like counts per week of items that occured in that week. For example:
15 tickets opened 5/26/18 - 6/1/18
5 tickets opened 6/2/18 - 6/8/18
12 tickets opened 6/9/18 - 6/15/18
but continually going back in time until the data allows or I restrict in some other way. I can't seem to find a clear example of how to achieve this and any help would be appreciated since I need to filter on that week format for ALL of our reports/dashboards.
Thank you
can you please share details about your source data
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |