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.
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.
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 |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |