week on week change

[Anonymous]

Hello experts! 

I have been following youtube tutorials on how to calculate a week on week change in a metric. And what I am getting does not work. Please help me to find out what I am doing wrong.

I have metrics:

WeekstartDate = 'invoices_granular'[createdAt]+-1*WEEKDAY(invoices_granular[createdAt],2)+1

and

WeekEndDate = invoices_granular[createdAt]+7-1*WEEKDAY(invoices_granular[createdAt],2)

and

WeekNum = WEEKNUM(invoices_granular[createdAt])

and

WeekRank = RANKX(ALL(invoices_granular),invoices_granular[WeekstartDate],,ASC,Dense)

and

Sales This Week = CALCULATE(SUM(invoices_granular[items.netRevenue]),FILTER(ALL(invoices_granular),invoices_granular[WeekRank]=MAx(invoices_granular[WeekRank])))

and

Sales Last Week = CALCULATE(SUM(invoices_granular[items.netRevenue]),FILTER(ALL(invoices_granular),invoices_granular[WeekRank]=MAX(invoices_granular[WeekRank])-1))

What I am getting does not make sense. 

The numbers do not add up and this gives me sales for Mon-Friday only, which does not match. The error is in the Sales this and last week calculation, and possibly somewhere in dates.

The actual numbers should be as follows

How do I make sales apprear for the week number and a week before that week number?

[audreygerred]

Here are two great sources for helping with week based time intelligence:

https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/

Week-related calculations – DAX Patterns

[Anonymous]

Hi @audreygerred , I had a read through both of these articles and this is beyond my skill unfortunately. I was hoping to fix what I have currently shown rather than redo it