Forum Discussion

Wajdi's avatar
Wajdi
Frequent Visitor
4 years ago
Solved

Average Of Duration

Hi Team

Can i pls have your support for the following ,i want to use the below extraction to generate :
-Average of the excecution per day per device (listed in column A) excluding week days (saturday & sunday is considerated a week day ) 
FYI, Colom B is calculated in millisencode and it's cummultaive per day (for each day will have many execution )

device/nameexecutiondate
Device A1012Wednesday, July 20, 2022
Device A469091Wednesday, July 20, 2022
Device A1696291Wednesday, July 20, 2022
Device A51791Wednesday, July 20, 2022
Device A765491Wednesday, July 20, 2022
Device A178991Thursday, July 21, 2022
Device A10891Thursday, July 21, 2022
Device A48991Thursday, July 21, 2022
Device A48191Thursday, July 21, 2022
Device A1006Thursday, July 21, 2022
Device A4665Thursday, July 21, 2022
Device A136691Thursday, July 21, 2022
Device A375391Thursday, July 21, 2022
Device A12291Thursday, July 21, 2022
Device A20591Friday, July 22, 2022
Device A12991Friday, July 22, 2022
Device A760891Friday, July 22, 2022
Device A48291Friday, July 22, 2022
Device A725991Friday, July 22, 2022
Device A23991Friday, July 22, 2022
Device A10591Friday, July 22, 2022
Device A4323Saturday, July 23, 2022
Device A132891Saturday, July 23, 2022
Device A2210Saturday, July 23, 2022
Device A44991Saturday, July 23, 2022
Device A3269Sunday, July 24, 2022
Device A1021Sunday, July 24, 2022
Device A71891Sunday, July 24, 2022
Device A32491Sunday, July 24, 2022
Device B1974Wednesday, July 20, 2022
Device B3405291Wednesday, July 20, 2022
Device B136991Wednesday, July 20, 2022
Device B256791Wednesday, July 20, 2022
Device B582691Wednesday, July 20, 2022
Device B6921Wednesday, July 20, 2022
Device A126791Thursday, July 21, 2022
Device A1261Thursday, July 21, 2022
Device B16291Thursday, July 21, 2022
Device B6507Thursday, July 21, 2022
Device B245991Thursday, July 21, 2022
Device B43491Thursday, July 21, 2022
Device B64991Thursday, July 21, 2022
Device B1012Friday, July 22, 2022
Device B40791Friday, July 22, 2022
Device B2146Friday, July 22, 2022
Device B107891Friday, July 22, 2022
Device B1012Saturday, July 23, 2022
Device B40791Saturday, July 23, 2022
Device B2146Saturday, July 23, 2022
Device B107891Saturday, July 23, 2022
Device B4483Saturday, July 23, 2022
Device B11391Saturday, July 23, 2022
Device B6237291Saturday, July 23, 2022
Device B1679291Saturday, July 23, 2022
Device A3662Sunday, July 24, 2022
Device B10191Sunday, July 24, 2022
Device B34291Sunday, July 24, 2022
Device B3201291Sunday, July 24, 2022
Device B27891Sunday, July 24, 2022
Device B1365291Sunday, July 24, 2022
Device B274791Sunday, July 24, 2022
Device A39591Monday, July 25, 2022
Device A8291Monday, July 25, 2022
Device B51591Monday, July 25, 2022
Device B13684291Monday, July 25, 2022
Device B9291Monday, July 25, 2022
Device A45491Tuesday, July 26, 2022
Device A1116Tuesday, July 26, 2022
Device B30391Tuesday, July 26, 2022
Device B14191Tuesday, July 26, 2022
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Wajdi ,

     

    Try formula like below:

    col_ =
VAR week_day =
    WEEKDAY ( 'Table'[date], 1 )
RETURN
    IF ( week_day IN { 6, 7 }, 0, 1 )
    M =
AVERAGEX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[device/name] = MAX ( 'Table'[device/name] )
            && 'Table'[col_] = 1
    ),
    'Table'[execution]
)

     

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Wajdi ,

     

    Try formula like below:

    col_ =
VAR week_day =
    WEEKDAY ( 'Table'[date], 1 )
RETURN
    IF ( week_day IN { 6, 7 }, 0, 1 )
    M =
AVERAGEX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[device/name] = MAX ( 'Table'[device/name] )
            && 'Table'[col_] = 1
    ),
    'Table'[execution]
)

     

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.