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
Hi JimJim
Based on the information in your file, the order of output and output_description is identical since one is derived from the other.
The output_description appears to be a simple concatenation of output with units_measure.
Therefore, it's difficult to understand your intended meaning. Could you please provide an example of the desired outcome?
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.