Date hierarchy

Hello J94 

The EOMONTH() function can be utilized to retrieve the last date of the month, formatted as "mmm-yy".

This approach ensures that the datatype remains intact, meaning the MonthYear column retains its date/time datatype rather than being converted to categorical.

By applying this method, the desired outcome should be achieved. An image illustrating a scenario is attached. Kindly implement the same technique and inform us if the issue persists.

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

Proud to be a Super User