Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to create a report which contains 5 columns representing up to 5 weeks for a month selected in the slicer). Our weeks end on Thursday.
My data has a column for Date, WeekEnd Date, and MonthEndDate. I'm stuck on how I would incorporate into the measures how to gather all data for the week which contains the 1st, 8th, 15th, 22nd and 29th.
Thanks!
could you pls provide some sample data and expected output?
Proud to be a Super User!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |