Forum Discussion
How to sort year
I have a date column with YYYY/MM/DD
I have seen a slicer to the visualization look like this one below.
2010/2011
2011/2012
2012/2013
2013/2014
etc....
Anyone knows how I can do it?
1 Reply
Try this calculated column formula
New Year = YEAR ( Date[Date] ) & "/" & YEAR ( Date[Date] ) - 1Or
New Year = YEAR ( Date[Date] ) - 1 & "/" & YEAR ( Date[Date] )You can then use this column to create a slicer, hope this helps
Thanks
