Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multiply values in columns (Different tables)

Say I have one table like this:  a 1,02 b -0,4 c -5 a -3,2 b 3 c -4,5   And the other table like this:  a 839403284 b 932848032 c 39842048   How to I m...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to my pbix file to see if it helps you.

    Create a measure.

    Measure = MAX('Table'[value])*MAX('Table (2)'[val])

    If I have misunderstood your meaning, please provide more details with your desired output.

     

    Best Regards

    Community Support Team _ Polly

     

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

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

If you know that there will only be 1 entry per item in the 2nd table then you can create a one-to-many relationship between the tables. You would then be able to use the RELATED function to do the multiplication. e.g. you could create a column on the first table like

Multiplied value = 'Table 1'[Value] * RELATED('Table 2'[Value])
Anonymous's avatar
Anonymous
Not applicable
4 years ago

It won't let me make that formula.. 😕