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;
andPlease Login or Register to view this content.
Please Login or Register to view this content.
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;Please Login or Register to view this content.
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?Please Login or Register to view this content.
Richard.
Bookmarks