Calculated table doesn't appear as a merge option

[GarzaD01]

Hello everyone,

I created a Crossjoined table with a DAX formula, when I try to merge this table it doesn't appear as a possible merging option.

I would be updating one of the tables I used to create the crossjoined one, do you know if there is another way I can merge this two (crossjoine table and a excel database) besides the Merging Option from the Query Editor?

Thank you

Diego G.

[Greg_Deckler]

Correct, because you created the table in DAX, Power Query doesn't know anything about that table. You will need to use something like NATURALINNERJOIN or NATURALLEFTOUTERJOIN functions, which can be a little challenging. I recommend @Phil_Seamark's insightful guidance and examples in his fantastic new book, Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence.

[GarzaD01]

Thank you very much!