Create a new related table from two other tables

[Antonio_garciaD]

Hello, everyone

I need to create a table based on two other tables data, these tables are already related.

I have two tables with the following data.

Table 1:

Equipment, Failures

Table 2:

Date, Shifts

And I need to create another table with the all the info joined together so I can create an average for every single Equipment, as shown below.

Any suggestions? please

Thanks in advanced.

[Antonio_garciaD]

Hello, Daniel

If I merge the two tables using your method, my data won´t be sortered by the relationships I want to keep. 

Actually there are more than two tables that I need to Merge and for doing it I need to find values based on the key column, which in this case is "Equipment".

I think this might be possible with the "RELATED" DAX function, but I don´t know how.

Do you know how to do it? 

Thanks in advance.

[Daniel29195 · Accepted solution]

@Antonio_garciaD 

if you have a 1 to many relationship ,  between the two tables, 

and you want to get data from the 1-side to the many side,  you use related. 

related will gt the data from the one side to the many side, base on the relationship .

https://dax.guide/related/

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Daniel29195]

@Antonio_garciaD 

you can create a new table base on these two tables ( using merge queries in power query ) .

go to power query. 

in the dropdowns, you select the tables you want to join . 

then in each table, you select the column that you want your join to be based on  .

NB :  you can choose the join type ( left, right,  full , .. .) 

let me know if this works for you .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠