Forum Discussion

rdiazd73's avatar
rdiazd73
Helper I
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

AlB's avatar
AlB
Community Champion
5 years ago

Hi rdiazd73 

So you want the highest pricein table2. That seems clear. What do you want for the brand? The brand that has the highest price? Another one? Please show the expected result

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers