Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date column and I have converted into month-year by doing
=Month(date) & '-' & (Year(date) )
now I have two questions:
1. I am getting a date as - as one of value
2. how to sort date in month-year.
I tried doing that by going to sorting --> expression -->Month(date) & '-' & (Year(date) ) but it didn't sort it out
Use this to convert date into monthYear and then sort numerically
Date(MonthStart(date)), 'MMM-YYYY')
Thanks Sunny but its coming correct in a list box but I am trying to use it in line table where
dim as =Date(MonthStart(date), 'MMM-YYYY')
measure as = count(id)
but chart is just showing year i.e consolidated of year.
Can you show an image of the line table?
sorry its line chart
Use the below piece of expression and check the Numeric value by Ace or desc..
MonthName(Date,'MMM-YYYY')
Then able to sort the values on month & Year.