I have a date in my fact table in the format DD/MM/YYYY and I want to convert it to Year-Month format MMM-YYYY. I will be using this new Month-Year field to aggregate my fact table by Month-Year like below.
It does give the same output and will be a shorter expression, but I have seen some issues with using MonthName in set analysis when you have to do >= or <= or > or < with it. I prefer to use Date(MonthStart()) because then you can its slightly easier to use. But it comes down to how you plan to use it