Forum Discussion
Danielecc
Helper II
Helper IIHow to get a single and multiple match between two tables
Hi everyone, I want to get a single/multiple match between two tables (Table 1 is a calculate table), and the result expected is a New calculated table. Tables are not related. I nee...
Hi Danielecc ,
You can do this on Power Query. Do the following steps:
- Add new blank query that refers to table 1
- Add a new step and refer to table 2
- Select the Impact column and unpivot other columns
- Filter the blank values
- Remove the attribute column
- Do a merger of the two table referincing the Source step and the Remove columns
- Do the expand of the table by the max of the IMPACT.
- Remove duplicates
See result below and in attach PBIX file
DanieleccHelper II
Helper IIHi Miguel, and thanks for your answer.
My "table 1" is a calculate table, then I can't do that. BUT I solve the problem doing a change of distribution on "Table 2".
I will accept as solution your answer cause must work with "no calculate tables.
Best regards
Hi Danielecc,
Do you mind explaining how you achieved this?