Forum Discussion

Sksam's avatar
Sksam
New Member
3 years ago

Hey , Need help for date sorting issue

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 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    3 years ago

    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])