Forum Discussion
Solved
How to Sort a Custom Date Column
Hi Everyone , I have a date table that has : date , year , month , quarter and ect. In addition, there is a new column I created it's called Week. The format for this column is : ( W + Week Number...
Hi ReemAlashhab ,
Approve with Avantika-Thakur , please try:
Create a new column weeknum:
Then use sort by column, choose weeknum:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ReemAlashhab .
You can try creating a lookup for week values and a column with Sort IDs.
Connect the main Week column with the Lookup week column and use the Week column from lookup in your visuals and then sort the week with Sort ID column. This should solve your purpose.
Thanks,
Avantika