Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everybody,
Im trying to join tables with no primary keys. Is it possible?
For example:
Table 1:
Table 2:
A need a table result where for each day I have all the rows of the table 2. I tried merging, but the result was this:
Thanks for helping.
Solved! Go to Solution.
Hi Lydia,
Thanks for your time. In fact, I solved this problem creating a column in both tables, filling the rows with the same result, for example "1".
Best regards.
If I have 2 queries and I want to join them without a key, I make a custom column in the first query that is the second query:
= Table.AddColumn(Source, "From Table 2", each #"Table2")
@ruanctorres,
Are there matching rows between the two tables? If not, it will return null result when you use "Merge Queries", please create new table using the DAX below and check if you get expected result. If you have matching rows between two tables, expand the new column after you use "Merge Queries", you can review this blog to get more details.
Table = CROSSJOIN(Table1,Table2)
Regards,
Lydia
Hi Lydia,
Thanks for your time. In fact, I solved this problem creating a column in both tables, filling the rows with the same result, for example "1".
Best regards.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |