Forum Discussion
Week over Week Comparison
- 8 years ago
You should have Year, Week Number and Weekday columns in your table. Or you can generate with calculated column.
WeekNumber = WEEKNUM(Table[Date],2)
WeekDay = WEEKDAY(Table[Date],2)
Then you can create a measure like:
Difference = SUM ( Table[Sales] ) - CALCULATE ( SUM ( Table[Sales] ), FILTER ( ALL ( Table ), Table[Year] = MAX ( Table[Year] ) && Table[WeekNumber] = MAX ( Table[WeekNumber] ) - 1 && Table[WeekDay] = MAX ( Table[WeekDay] ) ) )Regards,
Share your email id, i will share pbix with you
Hi,
Upload the file to Google Drive and shre the download link here. In the Calendar Table, please enusre that you have a week number column.
- Anonymous4 years agoNot applicable
Hi Ashish,
i need rolling six week vs current week option in slicer and my week starts from friday to thursday
it should exclude the current week and take respective weeks for rolling 6 weeks
Eg - i have data from Wk.1 to Wk.6 and wk.7 has only 4 days data and i am in 5th day so rolling 6 week would be Wk.1 (Friday) to Wk.6(Thursday) and current Week would have Wk.7 Friday till today-1
could you please assist me in getting this columns in power bi