Forum Discussion

SteelChampzz's avatar
SteelChampzz
Helper II
3 years ago
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...
Need Help
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    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

     

     

grantsamborn's avatar
grantsamborn
Solution Sage
3 years ago

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's avatar
SteelChampzz
Helper II
3 years ago

This does help alot!, thank you