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

     

     

SteelChampzz's avatar
SteelChampzz
Helper II
3 years ago

sure this how my data looks:

 

grantsamborn's avatar
grantsamborn
Solution Sage
3 years ago

Hi SteelChampzz 

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

  • SteelChampzz's avatar
    SteelChampzz
    Helper II
    3 years ago

    Yes, that is correct

     

    • 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