Forum Discussion
Solved
Average Per Working Days
Hello everyone, I'm trying to create a measure where I can get the average week total amount just for "ART-RT",my data looks like this: To get this measure in Excel it was the ART-RT Total...
Hi SteelChampzz
I'm not sure if this is what you want. (It seems too simple.)
I made up some sample data and came up with a simple model.
If this isn't what you want, I'll need some details on how you want to use it.
(Also, a weekly average is an average of the whole week - NOT an average of the daily averages.)
https://1drv.ms/u/s!AnF6rI36HAVkhPIeEthiRMCIS7mi5Q?e=1ZVmS6
One of the measures the I've built is a Sale Week total:
my measure looks like this
with that measure I've created cards for each week:
I would like to mirror these with a "AVERAGE" measure under all the Sales Weeks but when I replaced SUM with AVERAGE, it did not give me the correct value I need it.