Forum Discussion
adityavighne
Continued Contributor
Continued ContributorCalculate week over week
Hi Team, I want to calculate week over week sales data. but my week is from Friday - Thursday How to calculate in this way. WEEKNUM have only 1,2,3 options regards, Aditya
Please check the solution at https://www.dropbox.com/s/t7aybjemvs7zx9d/sales_analytics_weekWiseFriday_thru.pbix?dl=0
Friday week start has been created and rank used to find last week or week over week
if(WEEKDAY('Date'[Date])-6<0,WEEKDAY('Date'[Date])+1,WEEKDAY('Date'[Date])-6)
TomMartens
Super User
Super UserHey adityavighne ,
can you please provide a pbix that contains some sample data, but still reflects your data model, upload the pbix to onedrive or dropbox and share the link.
In the meantime, you might want to start with this to determine the StartDate for each week: https://community.powerbi.com/t5/Desktop/Week-commencing-in-DAX/m-p/241304#M107084
From this, you can derive an index column, that you can use to calculate the WoW change.
Regards,
Tom