topic Re: how to sort month year in my dimension in App Development

how to sort month year in my dimension

bhanu99 — Wed, 27 Sep 2023 19:31:40 GMT

I have a date column in the format as below:

I used Date(Date#("End Date",'MM/DD/YYYY'),'MMM YY')) as "End Date" to bring this into a uniform format.

Then i used floor(date(date#("End Date",'MM/DD/YYYY'),'MMM YY')) as MonthSort in my load editor , so that i can use this monthsort i sorting the dimension.

It is coming as below when i am using a table to view the values.

How to rectify this repetitions?

Re: how to sort month year in my dimension

MayilVahanan — Thu, 28 Sep 2023 04:03:34 GMT

For each date, it display the Month year. so it looks correct.

Suppose, if you want to see only one date per month, you can use MonthStart , so that, it can be achievable.

floor(MonthStart(date#("End Date",'MM/DD/YYYY')))

Date(MonthStart(Date#("End Date",'MM/DD/YYYY')),'MMM YY')

Re: how to sort month year in my dimension

Vegar — Thu, 28 Sep 2023 04:47:56 GMT

If you're not to picky with how MonthSort is formated then you could also use the monthname() function. This gives you what you need in an 'MMM YYYY' format. (I always use this function for this)

monthname( Date#("End Date",'MM/DD/YYYY') )