Forum Discussion
Helper IGet 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
Community ChampionYou 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
KarolinaThank you for your quick reply, that looks like it is what I'm looking for. But I cant find where to access that menu, could you explain that?
- tex628
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- Karolina
Oh, selecting the column enabled a menu! thanks, although it is ont exactly the same so I will put it here:
Thanks again!
Br,
Karolina