Forum Discussion
Expand table after merge changes my data
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:
What kind of join are you using? Inner or left/right?
Even though the order is different the actual data should be the same, you can add step ordering in the original order again.
Also, please consider that once you load the table to DAX the order of the rows is completely irrelevant, so try to avoid implenting any logic that way (again, that's in DAX, M has different behaviour)
Hi Stachu,
Thanks for replying me. I was using Left join. I've tried to add step between merge and expand. However, it seems like not working. My goal is to calculate the duration of each step in that sequence. So, I came up with get previous row value then calculate the duration.
you would need to add the step after expanding.
As for the previous row, here is a good method of achieving that: