Log table - how to show what was changed

[Mariollo]

I have a log table like the white one below.

I would like to add a blue column which will indicate what was changed in previous row (previous LogId for each EntityID).

What is the easiest way to do this in PQ?

[MAwwad]

Or using Dax like this :

Changed = VAR CurrentRow = MIN(Table[LogId]) RETURN CALCULATE(MIN(Table[LogId]), Table[EntityID] = EARLIER(Table[EntityID]), Table[LogId] < CurrentRow)

[MAwwad]

1. Create a custom column: Right-click on the log table in the Power Query Editor and select "New Source" > "Blank Query". In the new query, go to "Add Column" > "Custom Column", enter a name for the new column, and enter the following formula:

= List.Last(List.Select(List.Sort([EntityID]), each [EntityID] = [EntityID]))

1. Close & Load the new query to your worksheet. The new custom column will show what was changed in the previous row for each EntityID.