Forum Discussion
Expand table after merge changes my data
Hello All. Please help me with this. It's really strange. I want to get the previous row action date based on entity name and my index. it was previously sorted Entity name asc, action date desc. ...
Here is the solution I found. If you want get previous row value(in a certain sort) try this.
Refer to Previous Row for Subgroups in Power Query - YouTube
you would need to add the step after expanding.
As for the previous row, here is a good method of achieving that:
Here is the solution I found. If you want get previous row value(in a certain sort) try this.
Refer to Previous Row for Subgroups in Power Query - YouTube
Never try table.buffer trust me, that is the most stupid thing I ever found.