Forum Discussion
Calculate 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)
2 Replies
Hey 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
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)
