Merge tables in DAX

[Anonymous]

Hello all
I've create a table with DAX from 2 tables. Now i would love to merge it with a 3rd table (query) which has only 1 column.
I've been looking everywhere and didn't found any document or video that shows you how.
Is this possible, to merge these 2 tables?
Thanks in advance
Pedro

[v-frfei-msft]

Hi @Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.

[amitchandak]

@Anonymous , refer : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Anonymous]

Hi Amit
Thank you for your answer my friend but i needed a dax merge tables and not with power query, because that dax table doesn't show on power query.
So sorry if i didn't explain well.
But thank you so much anyway.
Best regards
Pedro

[camargos88]

Hi @Anonymous ,

I hope this link helps you: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Ricardo

[Anonymous]

Hi @camargos88 
First of all, thank you for the link cose it "sent me" to a function that i even didn't know that existed, naturalinnerjoin. But when i was reading the notes for that function, the last paragraph says that both tables should be related. I wish, because that's what i need, to relate them. So i did relate them, one to one in both directions, and then add a column to check if both are the same then TRUE else FALSE. And that's it. Didn't need to join them in DAX.
I've did some checkings and the result is what's expected. It seems it's working. But i didn't check them all because they're so many, you know?
Does all this make some sense to you? Do you think it's ok?

[camargos88 · Accepted solution]

Hi @Anonymous ,

The tables don't need to be related, they just need a common columns (by name).

Check it out: https://docs.microsoft.com/en-us/dax/naturalinnerjoin-function-dax.

Maybe that works, no ?

Ricardo

[Anonymous]

Awesome! Thank you so much Ricardo