week by week comparison---help

[srk_powerbi]

HI,

i have a requirement that compare 2 week's  sales data based on slicer selection, so i have slicers like below, when user selects values in slicers below, i need to show show data for  week 1 and week 2 side by side by location dimension and also %diff. I have date table with weeknumber column in it and Fact table with sales data  that maps to date dim with date.

slicer1 = Year 1   

slicer2 = Week 1

slicer 3= Year 2

slicer 4 = Week 2

i need table like this...please help

location	Week1 sales	week2 sales	%diff

[amitchandak · Accepted solution]

@srk_powerbi , for Period over period or Week over a week using two slicers refer to my video

How to use two Date/Period slicers
https://www.youtube.com/watch?v=WSeZr_-MiTg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=19

for Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8