Forum Discussion
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...
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.
AnamPatel
Resolver II
Resolver IIFirstly you can create a relationship between the two tables based on the common column. Now you can use the below DAX to do the multiplication -
Multilple = TABLE1[COLUMN1]* RELATED(TABLE2[COLUMN2])
Model Should look something like this, just a sample image -
Let me know this helped you.
It won't let me chose the right columns.. 😞
What should I do?- AnamPatel
Create a relationship between the two tables first.
That should be in order, but there are still some of the calculations that are completely wrong..