Forum Discussion
Many to Many relationship for below data.
Hi kapil512,
I don't think it make sense to get the cloumns from both tables for Many to Many releationship tables data into single Visual. Take below two tables as an example, for record "B 4" in Table1, which value in Table2[Column4] should be matched with it? How to dispaly all these columns in visual?
Or if you want to dispaly values in visual like below, you could create a calculated table via crossjoin two tables then filter.
DAX similar to:
Table4 = FILTER ( CROSSJOIN ( Table1, Table2 ), Table1[Column1] = Table2[Column3] )
A 1 gdh A 2 gdh A 3 gdh B 4 sthsrtj B 4 sga B 4 hh B 4 dh B 56 sthsrtj B 56 sga B 56 hh B 56 dh By the way, do mask sensitive data before uploading detailed data.
Regards,
Yuliana Gu
Hi kapil512,
I don't think it make sense to get the cloumns from both tables for Many to Many releationship tables data into single Visual. Take below two tables as an example, for record "B 4" in Table1, which value in Table2[Column4] should be matched with it? How to dispaly all these columns in visual?
Or if you want to dispaly values in visual like below, you could create a calculated table via crossjoin two tables then filter.
DAX similar to:
Table4 = FILTER ( CROSSJOIN ( Table1, Table2 ), Table1[Column1] = Table2[Column3] )
| A | 1 | gdh |
| A | 2 | gdh |
| A | 3 | gdh |
| B | 4 | sthsrtj |
| B | 4 | sga |
| B | 4 | hh |
| B | 4 | dh |
| B | 56 | sthsrtj |
| B | 56 | sga |
| B | 56 | hh |
| B | 56 | dh |
By the way, do mask sensitive data before uploading detailed data.
Regards,
Yuliana Gu
Thank you Yulgu,
Its working fine.
Thanks,
Kapil Dev