Share via

Concatenate function (DAX)

Anonymous
2015-11-12T09:04:26+00:00

I can't get my CONCATENATE function to work. Please help me with why this do not work.

Tried this to. Function accepted, but gets "Error" in column.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2015-11-13T02:53:22+00:00

    Hi,

    I don't think CONCATENATE() is a Power Query function (By the way, the name of Power Query's formula language is M, not DAX).  To concatenate, just double click on Month on the desired field in the Available columns section, type the special character in double quotes and then double click the next one.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest