Concatenate in DAX PowerBI

Question

How can I merge first name and last name columns and want to merge them into single column,and want to compare the results with other table,So how can i make it?

Answer 1

Use the following measures:

Concatenated Column = TableName[firstname] & " " & TableName[lastname]

and

Concatenated Measure = MAX(TableName[firstname]) & " " & MAX(TableName[lastname]) 

Want to learn more about Power Bi, Refer & learn Power bi   

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI