Forum Discussion
Avg Days in Project Process
Hello! I am trying to build a calculation that will give me the avg days between each component of the project process. For example: In the below excel file I have project ID 1 and I want to konw th...
HI nmck86
This calculated column gets close
Column =
VAR Wappr =
MINX(
FILTER(
'Table1',
'Table1'[Project ID] = EARLIER('Table1'[Project ID])
),
'Table1'[Date])
RETURN INT([Date] - Wappr)