I have two table like these: Table1 with Col1, Col2 and Tbale2 with Col3, col4
I want to do 2 task:
1- creating a new column in Table1 that lookup Col4
2- a column that include Table1.Col2 * Table2.Col4 as Col5
3- a measure calculate Sum (Table1.Col2 * Table2.Col4)
how can I do it??