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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

It's a simple, many-to-one relationship. 
One table has only one occurence of each value, while the other table has lots of occurences of each value. Does it matter wheter it's formatted as numbers or text? (the values that are related are 4-number values)

johnt75's avatar
johnt75
Super User
4 years ago

It doesn't matter whether they are numbers or text but they both need to be the same. and if its text you need to make sure that there are no leading or trailing spaces in either column, as that would throw the relationship out

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    All of that should be in order.