Get date as month and year, but keep data type date

You can change the display format of a date here:



Another way to do it is by doing what you're propsing with the FORMAT() but also creating a sorting column that sorts the initial year/month column.

Br,

J

Select the column or measure that you want formatted from the menu on your right. Once it's highlighted you can then open the modelling section and open the format dropdown:



Br,
J