Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |