Perform Join between 3 values?

[Anmolgan]

I need to write a DAX using which i will be able to perform joins among 2 tables on 3 fields, I need to put up my rates among those rows where the join is being performed, now I now how to do this in Power Query, since I am fetching data from SAP-BW, how can I perform this using DAX, since data volume is huge and we are looking for any easier way of doing this.

[v-xuding-msft]

Hi @Anmolgan ,

You could use the function of CROSSJOIN and RELATEDTABLE to join two tables. If you can't solve by yourself, you could post some sample data and expected result that we will help you as soon as possible.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.