Forum Discussion

danakajoel's avatar
danakajoel
Frequent Visitor
5 years ago
Solved

SUMPRODUCT in Matrix Visual

HI,   I have a relatively simple dataset copied below where I am seeking to replicate SUMPRODUCT from Excel by working out the difference between sub asset classes between two dates and applying a ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi danakajoel 

     

    try it

    test= SUMX(VALUES('Benchmark Performance (GBP)'[Sub AA]),[Value % difference from Period Start GBP])
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi danakajoel 

 

try it

test= SUMX(VALUES('Benchmark Performance (GBP)'[Sub AA]),[Value % difference from Period Start GBP])
danakajoel's avatar
danakajoel
Frequent Visitor
5 years ago

Hi Vera. Absolutely perfect. Thank you. I'd spent hours investigating and trying ISINSCOPE etc to no avail. I'll need to read up on the VALUES function to better my understanding but problem solved 🙂