Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a column of descriptions , How Do I Sort that column ? So that I can compare with Previous value to identify multiple keys
ID Desc
1 Apple
2 Ball
3 Cat
4 Apple
5 Cat
I need to sort this column:
ID Desc
1 Apple
4 Apple
2 Ball
3 Cat
5 Cat
Final Output
ID Desc CalColumn
1 Apple 1,4
2 Ball 2,6
3 Cat NULL
OR
ID Desc CalColumn
1 Apple X
2 Ball NULL
3 Cat X
4 Apple X
5 Cat X
Solved! Go to Solution.
Hi,
Sorting will be easy. Click dropdown of the column and choose Sort Ascending in Query Editor. We also can add an index to keep the new order. Could you tell me the mean of the output?
Best Regards!
Dale
Hi,
That all depends on the output you want. Dax has some funtions to do sorting work. But they don't work the way like sort here. Such as Rankx, TopN.
Best Regards!
Dale.
Hi,
Sorting will be easy. Click dropdown of the column and choose Sort Ascending in Query Editor. We also can add an index to keep the new order. Could you tell me the mean of the output?
Best Regards!
Dale
Can I do that in Dax ?
Hi,
That all depends on the output you want. Dax has some funtions to do sorting work. But they don't work the way like sort here. Such as Rankx, TopN.
Best Regards!
Dale.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |