I want to create a measure which will calculate the average duration of task(s) completed by a machine.
There are two task types: 'Task', and 'Parent Task'. Every 'Parent Task' has one 'Task'.
All of the data I require is held against the 'Task', except for one column which is recorded against the 'Parent Task'.
What I want to achieve, looks like this (the right-most column); can anyone suggest how to do this?
Go to Solution.
Please try the formula below.
Measure 2 =
AVERAGE ( Table1[Duration] ),
FILTER ( ALL ( Table1 ), Table1[Task] = EARLIER ( Table1[ParentTask] ) )
View solution in original post
That worked really well, thank you Dale!
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!