Forum Discussion
Average Store Sales
I am looking at a day by day view of how many stores are open, their total sales, and what the average per store is in sales. I would want the week total to be different. The average per store would ...
Nevermind I got it working with
SUMX(VALUES('4-4-5 Date'[DateKey]),CALCULATE(DIVIDE([Net Sales],[# Stores Day])))
Unfortantely my file is full of sensitive data. I really just need a measure that can add up a daily value for the whole week. So if I have average sales on a daily level, what is the total of 7 of them each week.
Nevermind I got it working with
SUMX(VALUES('4-4-5 Date'[DateKey]),CALCULATE(DIVIDE([Net Sales],[# Stores Day])))