Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)
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?

1 Answer

0 votes
by (22.5k points)

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

 

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 24, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Mar 29, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Mar 29, 2021 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...