how to get the product of 2 columns from different tables

[Anonymous]

Hi,

I have 2 column from different table that i need to multiply on.. how do i do it on Dax?

ECM Cost Table =Recurring Cost Amount

ECM Data Table = Period

thank you in advance

[VijayP · Accepted solution]

@Anonymous 

If those tables are connected with relationship , you can use related function! But question is not complete hence answer might be exact

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on my testing, please try the following methods:

1.Create the sample table.

2.Create the measure to calculate the two columns values.

Measure = SUMX(
    'ECM Data Table',
    'ECM Data Table'[Period] * RELATED('ECM Cost Table'[Recurring Cost Amount])
)

The result is shown below.

You can view the following link to learn more information.

Solved: Multiply two columns from different tables with a ... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

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

[VijayP · Accepted solution]

@Anonymous 

If those tables are connected with relationship , you can use related function! But question is not complete hence answer might be exact