Forum Discussion
PowerBI First Name and last name
| 1 | Yokesh Mohan | |
| 1 | Yokesh Kannan | |
| 1 | Yokesh Mahan | |
| ID | Customer |
| 1 | Yokesh |
| 2 | Prateek |
I want ouput as
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
2 Replies
mlsx4Memorable Member
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
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