Merging an Import table and a calculated Table

[dancarr22]

Hello,

I have a table X which we is loaded via Import.  And a second table Y which is created by 

DISTINCT(

    SELECTCOLUMNS(.  i.e. a calcualted table

I'm trying to do a merge on these tables but PBI doesn't seem to recognize table Y - the calculated table.  Is this correct?  Cannot do merges on calcualted tables?

Thanks,

Dan

[dancarr22]

Got it - thanks @lbendlin 

[dancarr22]

Thanks @lbendlin 

NestedJoin in M

In PBI Desktop clicking on 

[lbendlin · Accepted solution]

You cannot reach back into Power Query from DAX.

[lbendlin]

Please define what you mean by "merge" - UNION or NATURALxxxJOIN ?