Previous week comparison calculation based on Slicer date calculation

Hi, Anonymous 

 

You can try the following methods.

Sample data:

Measure:

Current week Sales = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Date','Date'[Week]))

Previous week Sales = CALCULATE(SUM('Table'[Value]),FILTER(ALLEXCEPT('Date','Date'[Week]),WEEKNUM([Date],2)=WEEKNUM(SELECTEDVALUE('Table'[Date]),2)-1))

Comparison = DIVIDE([Current week Sales]-[Previous week Sales],[Previous week Sales])

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.