Forum Discussion
Anonymous
6 years agoNot applicable
matching two tables with multiple values
I have two tables. TABLE 1 Product ID ICD Code 1 A 1 B 1 C 2 A 3 B 3 D My second table looks like this: TABLE 2 Product ID 1 3 I would like t...
- 6 years ago
Hi Anonymous
you can do it in report view like this:
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
amitchandak
Super User
6 years agoAnonymous , Power query way
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
DAX way
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/