PowerBI First Name and last name

[YokeshMohan01]

1	Yokesh Mohan
1	Yokesh Kannan
1	Yokesh Mahan

ID	Customer
1	Yokesh
2	Prateek

I want ouput as 

[v-shex-msft · Accepted solution]

Hi @YokeshMohan01 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

BTW, if you mean to show the first table name field values when you use table 2 field as category, you can create relationship based on the id field. Then you can use second table field as row, first table as column to create a matrix visual to show the similar effects.

Regards,

Xiaoxin Sheng

[mlsx4]

Hello @YokeshMohan01 

Can you explain a bit what's your problem and what you're trying to achieve? If you have these two tables, just using a relation ship between them through ID will do it