Hi,
have a question regarding joing dates or number and text in power Q;

If I have a date column and then create two more so;

   Date.Year(date)
and
 Date.MonthName([Date])

and then go to addcustomcolumn and join them
  [Year]&"-"&[Month] ,
But if I don't add these helper columns I seem to need to covert the year to text first;


Text.From(Date.Year([Date]))&"-"&Date.MonthName([Date]))
why? I can see that the DateYear does return a text value ( left side) , but if that's the case shouldn't it work within the concatenation?

Richard.