Average Per Working Days

[SteelChampzz]

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.

[SteelChampzz]

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.

[grantsamborn]

Hi @SteelChampzz 

Could you please show an example of the dataset?

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[SteelChampzz]

sure this how my data looks:

[grantsamborn]

Hi @SteelChampzz 

Does an OrderType of "R" indicate if it is "ART-RT"?

[SteelChampzz]

Yes, that is correct

[grantsamborn · Accepted solution]

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

[SteelChampzz]

This does help alot!, thank you