Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
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')
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') )