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 TIME1 1/1/2018 52 1/1/2018 13 1/1/2018 31 2/1/2018 62 2/1/2018 23 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.
Go to Solution.
View solution in original post
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!