Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Or using Dax like this :
Changed = VAR CurrentRow = MIN(Table[LogId]) RETURN CALCULATE(MIN(Table[LogId]), Table[EntityID] = EARLIER(Table[EntityID]), Table[LogId] < CurrentRow)
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:
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |