cumulative Week to Date

[eman-saad]

I want to calculate the week to date compared to last week, but on a cumulative basis, I want to compare the first day of this week with the first day of last week, and tomorrow compare first & second day of this week with first & second day of last week etc …

[Greg_Deckler · Accepted solution]

@eman-saad Not accounting for year changes, you could add a WEEKNUM column and WEEKDAY column and simply compare the current value with WEEKNUM - 1 and equal WEEKDAY. If you want to account for changes in year, you could use Sequential. https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116

Sample data would help me be more specific. All of this assumes you have a date column of some sort.