Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Right, you want to use EARLIER like this:
Column = VAR __table = FILTER(ALL('Table2'),[Car] = EARLIER([Car]) && [Sequence] <= EARLIER([Sequence])) RETURN SUMX(__table,[Hours])
Hi @Greg_Deckler.
Could I please kindly ask you to stop using EARLIER, which is a rather hard-to-understand function and confusing for newcomers, and use the modern and easy way to address previous row contexts? The way is called VARiables. EARLIER is a remnant of the past and should rest in peace.
Many thanks.
Best
D.
Dear @Anonymous
Kindly explain how does it work?
Thanks
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |