Sorry. I'm not quite sure I understand you.
These two are calculated columns:
format_Date = FORMAT(Query1[Date], "dd-mmm-yyyy")
date_Sort = RANKX(Query1, [Date],,ASC, Dense)
Sort Ascending by date_Sort
Change Header options:
Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!