Hey , Need help for date sorting issue

[Sksam]

I have a column called "visual date"  which contains following data for example...data type of column is "text".

( i have added visual date column in data view tab by using DAX)

2023

2022

2023 -Qtr 1

2022 -Qtr 2

Jan - Second half - 2022

March - First half -2023

Week - 47 - 2022

Week 15 - 2023

Dec - 202201/05/2022

and so on ...

I want to sort visual date column by date. How to do this ?

@amitchandak 

[grazitti_sapna]

Hey,

Try using this, whenever you are adding your visual date column in data view by using DAX, there only try to use DATEVALUE function  which will help you to sort your date column by date format.

For Example like this:-

SOLUTION: new date = DATEVALUE('Superstore - Orders (1)'[Order Date].[Date])

[lbendlin]

what would be the expected outcome based on this sample data?