Forum Discussion
Solved
Concatenate issues
Am I missing something very obvious? Why doesn't my desktop recognize concat? I copied the spelling from the documentation just to be sure...
Concatenate works in a DAX formula but not in the query editor. You can use an ampersand, but that only works with text values, so you also have to convert the numbers to text. This should work:
Number.ToText([Month]) & Number.ToText([Year])
Concatenate works in a DAX formula but not in the query editor. You can use an ampersand, but that only works with text values, so you also have to convert the numbers to text. This should work:
Number.ToText([Month]) & Number.ToText([Year])
Thanks!