Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Average Measure with filter

Hi,   I want to calculate the average days it take to complete an order with product type 'Computer'. How can I calculate that in a measure? This is a sample of my data: OrderID    OrderDate ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    you can create a column and measure

    days = DATEDIFF('Table'[OrderDate      ],'Table'[OrderCompleteDate     ],DAY)

Measure = AVERAGEX(FILTER('Table','Table'[Product     ]="Computer"),'Table'[days])

     

    or  you can create a measure directly.

    Measure 2 = 
VAR tbl=ADDCOLUMNS(FILTER('Table','Table'[Product     ]="Computer"),"day2",DATEDIFF('Table'[OrderDate      ],'Table'[OrderCompleteDate     ],DAY))
return AVERAGEX(tbl,[day2])

    pls see the attachment below.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You may create a calculated column formula to calculate the difference between the 2 date columns.  Give a heaing to that column as Days.  Then write this measure

Measure = average9Data[Days])

To your table visual, drag Product and the Measure.