Forum Discussion
Tuan
Helper III
Helper IIICalculating 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
amitchandak
Super User
Super UserTuan , 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