Forum Discussion
Anonymous
7 years agoNot applicable
Help with Multiply columns by reference table
Hi, I need help with multiplying different columns. First, sum columns Sales and Pro then muliply it by the Growth from the other table when it match the name. I've done with the vlookup...
- 7 years ago
First you have to create a relationship as pic below.
then write these measures
Growth A Measure = SUMX ( 'Sales Table'; 'Sales Table'[Sale] * 'Sales Table'[Pro] * RELATED ( 'Growth Table'[Growth A ] ) )and
Growth B Measure = SUMX ( 'Sales Table'; 'Sales Table'[Sale] * 'Sales Table'[Pro] * RELATED ( 'Growth Table'[Growth B] ) )and the result is
PattemManohar
Community Champion
7 years agoAnonymous Could you please post your expected output as well.