topic Re: How order Number of week ascending in my calculated table in DAX Commands and Tips

How order Number of week ascending in my calculated table

Anonymous — Sat, 19 Nov 2022 11:14:23 GMT

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.

Re: How order Number of week ascending in my calculated table

daXtreme — Sat, 19 Nov 2022 12:53:39 GMT

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.

Re: How order Number of week ascending in my calculated table

Anonymous — Sat, 19 Nov 2022 12:58:52 GMT

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?

Re: How order Number of week ascending in my calculated table

daXtreme — Sat, 19 Nov 2022 13:00:32 GMT

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

Re: How order Number of week ascending in my calculated table

Anonymous — Sat, 19 Nov 2022 13:08:15 GMT

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

Have a nice day.