merge two tables on Directquery Mode

[achrafkasmi]

Hi, 

I have two tables in DirectQuery mode: V_demandeStockD and V_tranStockD.

I want to merge the two tables , and adding a columns on V_demandeStockD to have the ItemCode and Dscription from V_tranStockD for each expr1.

PS: there's a relation between Expr1 on V_demandeStockD and DocNum on V_transStockD.

Can you please help me add those columns in the table Tasks?

[lbendlin]

Calculated columns on Direct Query sources can only work in the context of the row. 

Direct Query queries are run against the data source.  If you want to merge the tables then you need to merge them at the data source (via a view, for example)