Forum Discussion
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 Amount / 4 (since the first working week started on the 3rd)
How would I create this into a measure using "specific dates"(Jan.2-Jan.6), and with FILTERS to show the average just for ART-RT?
Thanks for any help.
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
7 Replies
sure this how my data looks:
Hi SteelChampzz
Does an OrderType of "R" indicate if it is "ART-RT"?
One of the measures the I've built is a Sale Week total:
my measure looks like thiswith 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.
