Forum Discussion

shansenTrek's avatar
shansenTrek
Frequent Visitor
6 years ago
Solved

Average Days to Complete a Task

Hi Team,   First time poster, long time reader/follower.   I am trying to create a measure to give me the average days to complete a task.  We have multiple people working on several projects tha...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Perhaps:

     

    Avg # of Days = 

      VAR __Table = 

        SUMMARIZE(

          'Table',

          [Project],

          "Start Date",FIRSTDATE( 'Table'[Date] ),

          "Last Date",LASTDATE( 'Table'[Date] ),

          "# of Days",DATEDIFF( [Start Date] , [Last Date] , DAY )
        )

    RETURN

      AVERAGEX(__Table,[# of Days])

amitchandak's avatar
amitchandak
Super User
6 years ago

shansenTrek ,Try like


AverageX(summarize('Table', 'Table'[Project Name], 'Table'[Task Name],"_diff",datediff( FIRSTDATE( 'Table'[Date] ),LASTDATE( 'Table'[Date] ),day))
,sum([_diff])/distinctCOUNT([Project Name]))