Hi @KieftyKids,
Have you looked into this segmentation technique?
.
.
Think there are two approaches:
- If you are doing a Week over Week comparison it would make sense to me to calculate the difference over completed weeks only. So looking at the total from last week vs the total for the week before that. For the current week however you could do a “To Date” comparison with last week. Example if your data is until Thursday then compare with LW data until Thursday…
- But another approach could be to always compare the last 7 days with the 7 days before that - so day by day contiguously moving through time. However I think this will make it harder to compare the daily figures and get any insights from it…
Thank you for opening up a new thread and providing a PBIX 