Forum Discussion
Solved
Matrix Column sort following an IF statement
I have a set of data that has dates in it and added a column in the data view (Because i didnt know how to do it in query editor) with the following statement: Overdue Status = IF([Due Date]<TODAY()...
Hello astorey1
The easiest way to do this is by creating a new column that represents your sort order and use the "Sort by column" option in the modelling ribon.
Overdue Status = IF([Due Date]<TODAY(),1, IF([Due Date]-30<TODAY(), 2, 3))Kind regards
Joren Venema
Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.
Hello astorey1
The easiest way to do this is by creating a new column that represents your sort order and use the "Sort by column" option in the modelling ribon.
Overdue Status = IF([Due Date]<TODAY(),1, IF([Due Date]-30<TODAY(), 2, 3))
Kind regards
Joren Venema
Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.