Forum Discussion

D_PBI's avatar
D_PBI
Post Partisan
3 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.           

D_PBI's avatar
D_PBI
Post Partisan
2 years ago

Anonymous - thank you.