Forum Discussion
Solved
combinar consultas
hola power bi-team agradecere si me pueden ayudar, con un problema para obtener datos de una tabla a otra y que metodo utilizar table1 table2 codigo precio ma...
rdiazd73
If you want to create report to include both tables values, you can create a many to one relationship for table 1=>table 2 using [codigo[ column, then you can put the column in one table visual and do calculation on table 2 using related(table1[column]).If you want to put 2 tables in 1 table, you can just use merge or append feature in query editor.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Hello Thank you x look at it
the code always corresponds to the same brand
the problem that has arisen me to merge tables is that Table 1 has hundreds of records
and table 2 a few, and it transforms table 2 into thousands of rows
Best regards
Ricard