Forum Discussion
Post Prodigysorting comments from newest to oldest - Matrix
I have a matrix with open text comments from a survey.. I am trying to organize them from newest to oldest. I tried to use "sort column by' Completion date but it's giving me an error. One column has dates, the other has texts? However, getting the below error message, what can be done? In query editor, I have the date set to date/time format, and the comments to text.
2 Replies
- amitchandak
Super User
Try to create a dense rank column on date and then try to use that column to sort comment
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
- v-eachen-msft
Community Support
Hi jcastr02 ,
You could check if your tables have relationships to affect sorting feature.
You could also take a look at the following blog about creating a custom sort order table to achieve customer sort order:
