Forum Discussion
Helper IIAlternative to Power query for calculated columns
Normally if I want to change the order of a column into descending order, I just click on Transform Data > Select the column I want to arrange > click the down arrow > and then select Sort ascending.
But if it is a calculated column I am not able to do this as it does not appear in Power Query. So if I want to do what I did above to a calculated column, how do I do it with DAX or something?
Hi RingoSun
Not exactly sure what is your issue, but why do you need to go to Power Query for sorting your data?
In Power BI Desktop you can right click on your column and there you will find the option of sorting ascending/descending.
Let me know if that works.
Thanks,
Sanket
If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.
1 Reply
Hi RingoSun
Not exactly sure what is your issue, but why do you need to go to Power Query for sorting your data?
In Power BI Desktop you can right click on your column and there you will find the option of sorting ascending/descending.
Let me know if that works.
Thanks,
Sanket
If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.