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)
amitchandak
Super User
Super UserPlease 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)