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
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