I have created a column using below DAX:
Hour = format(Data[FIRST_TOUCH_DATE_TIME], "hh:mm:ss AM/PM")
now I want to sort values as P.M Values will come at Upper side, so i will basically sort by Descending order. How can I achieve this?
Go to Solution.
you have to create another column with the expected order and then tell your Hour column that it should be sorted by the newly created column (see the attached screenshot).
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!