Forum Discussion
Global Filter for all reports
Srikarnandan7 you need to have a table with the column you trying to join on, that has unique values, so if you have multiple values of that column in both tables, you need to build a new table with only the unique values of the decription, build and build a relationship from both those tables to that table
alternatively if both those tables are the same structure and content you can just append one on top of the other in power query or do a union in dax. depends on the data which is hard to tell with the info you given
Srikarnandan7 you need to have a table with the column you trying to join on, that has unique values, so if you have multiple values of that column in both tables, you need to build a new table with only the unique values of the decription, build and build a relationship from both those tables to that table
alternatively if both those tables are the same structure and content you can just append one on top of the other in power query or do a union in dax. depends on the data which is hard to tell with the info you given
Hi vanessafvg
I have created a new table as you suggested with unique value..it worked as expected. Thans much for the help