Forum Discussion
Solved
Calculating Sales Per Week (Partial)
I'm trying to calculate Sales Per Week. The problem i'm having is the Partial weeks since im using a Regular Calendar Year. Since there are only 2 days in week 27 for June, I was trying to get th...
Tuan , You can try divide by distinct count of date
divide(sum(Table[New Sales]),distinctcount(Table[Sales Date]))
Prefer to Date table and have Week there
Assuming you have a Date table, you can just use
Weeks = COUNTROWS('Date'[Date])/7
If you don't have a Date table, and potentially have no rows on some dates, you could use
Weeks = (DATEDIFF(MIN(Table[Date]), MAX(Table[Date]), DAY)+1)/7
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat