Forum Discussion
Solved
Retrieve columns from a Direct Query table into a Import Mode table, performing an aggregation too.
Hi I have the following Import Mode table named 'Sales': I also have the following Direct Query table named 'Branch': I would like to perform a SUM on the Amount column, per TYPE a...
Hi D_PBI ,
If you don't want to create a relationship, you can try creating a calcualted table using DAX.
Table 2 = FILTER(CROSSJOIN('Table','Table_1'),[Ref No.]=[Code])It's the result.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
