Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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.
@Anonymous , refer : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
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
Hi @Anonymous ,
I hope this link helps you: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Ricardo
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?
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
Awesome! Thank you so much Ricardo
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |