next
1 Topic
How to get value of the next row for a certain category?
I have been able to create a calculated column using the EARLIER function, however I am unsure on how to find the next row (or more than 1 row earlier for that matter). The DAX below is what I have used to find the previous Sample Date for the same unit number. Can someone please tell me how I would find the next sample date and if there is a better way of writing my current formula? I feel like using MAX or SUM here is a little dodgy as I am not actually finding either, I just want to return a single value. = CALCULATE ( MAX ( [Sample Date] ), FILTER ( 'Sample Data', 'Sample Data'[Sample Date] < EARLIER ( 'Sample Data'[Sample Date] ) ), 'Sample Data'[Unit Number] = EARLIER ( 'Sample Data'[Unit Number] ) )Solved12KViews0likes5Comments