Select the max value from two columns by row and then use those values to make antoher measure

[davidibarrag]

Hello,
Can somebody help me with the following problem.
I have two value columns that I need to compare them row by row to get the max value from the two columns from each row. Then multiply it, whether the max value is from those two columns, for the values in another column (a third column). 
For Example:

Column A  Column B Max Value Column C Multiplication

1                3               3               6                3*6

3                5               5               4                5*4

6                2               6               7                6*7

1                6               6               9                6*9

2                1               2               10              2*10

Thank you so much.

[Anonymous · Accepted solution]

HI @davidibarrag ,

Try these steps:

Add new column with this formula:

Column = MAX([A],[B])

A and B are the name of my Columns 

I get output as follows:

Than use this measure for multiplication 

Measure 3 = 
SUM('Table (2)'[Column]) * SUM('Table (2)'[C])

my output:

Let me know if this works

Thanks,

Tejaswi

[davidibarrag]

Thanks a lot it worked.