Good Morning
I am struggling with the Earlier function as I am not able to make it work.
I have a column called ID, another called DATE and another called TIME
as an example:
ID DATE TIME
1 1/1/2018 5
2 1/1/2018 1
3 1/1/2018 3
1 2/1/2018 6
2 2/1/2018 2
3 2/1/2018 4
...
As you can see I have the date, and the time that is taken for ID nº X to finish.
I want to calculate a measure that tells me the Maximum time that takes for the ID to be finished, in this case for ID 1 it would be 6 as an example.
THe formula that I have used is the following one:
Medida = calculate(MAX(Table1[TIME]; FILTER(Table1; Table1[ID] = Earlier(Table1[ID]))
But I am not able to make it work as it tells me that there is an error in the Measure.
Can anyone help me in order to accomplish this task? Thanks a lot.
