Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |