Forum Discussion
Index column in power query based on date sorting
Hello, I have seen similar posts to this but wanted to throw a question out there--I have created a running totals column in the power query, which I would like to generate based on the date in asce...
Hi lenafherold ,
I think you want an index column grouped by the date column.
Here's my solution.
1.Right-click on the date column and select Group By.
2.Select All Rows.
3.Add an index column.
4.Expand the column.
You can check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Excellent, i was looking for this very solution. Thanks!