How order Number of week ascending in my calculated table

[Anonymous]

Hi, i created a calculated table using summarize.  I want to have the second column ordered ascending, i dont know how to do that. We have to consider that we have many products, so i cant apply the filter order ascending in the second column because if i do that the productos will mess up.

[daXtreme · Accepted solution]

Basically, ordering a column here by clicking on the triangle next to the name is pointless as it's only a visual ordering and does not affect anything else. It's just for you to see the beginning/end of the data according to this sort order.

[Anonymous]

Ty for your answer. i want to do that in power query, because i want to do an operation using a row and previus row. Can i do what i ask inpower query?

[daXtreme]

Yes, you can do it in PQ. And you can do things in PQ about which you've never even dreamt.

[Anonymous]

Ty, im going to search how, and if i have more questions im going to open a new question.

Have a nice day.