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.
tamerj1
Community Champion
Community ChampionHi Anonymous
My Undestanding that you cannot create calculated columns and you cannot create or edit relationships. Then try to create New Measure
NewMeasure =
SUMX (
Table1,
VAR Name = Table1[Name]
VAR Value1 = Table1[Value]
VAR Value2 =
MAXX ( FILTER ( Table2, Table2[Name] = Name ), Table2[Value] )
RETURN
Value1 * Value2
)
Hello, in the idea you provided, what is the "name"? i understand what table and values are but i dont understand whats supposed to go where is says name