Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SumProduct DAX formula needed

Hi Team,   I need help on creating SumProdut same as excel   Table1   Date EUR USD GBP Total 6/1/2017 0.00 -17375965.81 24889.80 -17343852.99 6/2/2017 0.00 -17375965.81 16.5...
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous there is may ways to do this, assuming these two tables are related on date with 1 to 1 relationship, you can add following column:

     

    Total = 
(Table6[EUR] * RELATED( Table7[EUR] ) ) +
(Table6[GBP] * RELATED( Table7[GBP] ) ) +
(Table6[USD] * RELATED( Table7[USD] ) )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous is date unique in both tables?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes