PROCX or EARLIER function in Power Query

Hi angelobruch ,

To what I can understand from your description you want to pick up the values of the first datetime after value 1 correct?

So has you present if you first line is picking up line 2 value and the lines 13 and 14 are picking up value of line 15.

To do this in the query editor I believe the best option is to follow the steps below:

• Sort your data by Date and the other columns that make this change in date readable (for example I assume that this is done by Produto)
• Add the following custom column:

if [Estado Lógico] = 0 then [Data/Hora] else null

• Right click the new column that was created and do a FILL UP

This will fill the values that are null with the values that are on the row below.

Can't replicate this on your file since it's connected to your database.