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;
and![]()
Date.Year(date)
![]()
Date.MonthName([Date])
and then go to addcustomcolumn and join themBut if I don't add these helper columns I seem to need to covert the year to text first;![]()
[Year]&"-"&[Month] ,
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?![]()
Text.From(Date.Year([Date]))&"-"&Date.MonthName([Date]))
Richard.
Bookmarks