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

rdiazd73 

Create these two calculated columns in Table2

Precio =
CALCULATE (
    MAX ( Table1[Precio] ),
    FILTER ( ALL ( Table1[codigo] ), Table1[codigo] = Table2[codigo] )
)

 

Marca =
CALCULATE (
    MAX ( Table1[Marca] ),
    FILTER ( ALL ( Table1[codigo] ), Table1[codigo] = Table2[codigo] )
)

 

All this can also be done in PQ

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