Forum Discussion
Sort one column by another - messy data
This is the opposite of what you asked in the original question 🙂
And it's solvable. Here are the steps you need to take:
1. From PQ duplicate table :
2. Remove all the columns except 2 needed :
3. Remove duplicates from output description:
4. Filter out "null" (if you have)
5. Close and apply
6. create a relationship between the sort table and the main table
7. In the sorting table apply a wanted sorting logic :
8. Use the sorting table as a slicer, it will filter the main table due to their relationship :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
This is the opposite of what you asked in the original question 🙂
And it's solvable. Here are the steps you need to take:
1. From PQ duplicate table :
2. Remove all the columns except 2 needed :
3. Remove duplicates from output description:
4. Filter out "null" (if you have)
5. Close and apply
6. create a relationship between the sort table and the main table
7. In the sorting table apply a wanted sorting logic :
8. Use the sorting table as a slicer, it will filter the main table due to their relationship :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983 , thank you so much, I did indeed mess up my original post and have edited it to prevent others from being confused. I really appreciate your help.
I'm always happy to help, and of course, my comments are not meant to be condescending or prove you wrong. Rather, I'm trying to clarify what is needed so I can better assist you 🙂