Forum Discussion
Date range issue
Anonymous , The format YYYY-YY is self sortable. from three dots it should sort .
Else you can create a fate column like
In power Query
#date(Number.FromText(Text.Start([Year],4)),1,1)
or dax
Date(Left([Year],4),1,1)
In case you create a column in DAX
also create
Year 1 = [Year]
and use Year 1 in visual and this should have a date as the sort column
why refer : How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c
Super UserAnonymous , The format YYYY-YY is self sortable. from three dots it should sort .
Else you can create a fate column like
In power Query
#date(Number.FromText(Text.Start([Year],4)),1,1)
or dax
Date(Left([Year],4),1,1)
In case you create a column in DAX
also create
Year 1 = [Year]
and use Year 1 in visual and this should have a date as the sort column
why refer : How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c
Oh, it was as simple as sorting. Thanks for taking the time to respond!