Forum Discussion
Benchmark Weighted Average
You lost me on the blended weights, and I also get slightly different results for the third table.
Attached is how far I got.
Thanks lbendlin
I should have been clearer in my description but you are on the right track. But as you can see, the differences occur when there are mismatches between Issuer(s) in the Benchmark and the Issuer(s) in the Fund.
My current, not so elegant solution is by creating another query which merges all the necessary columns. I'd settle for it, but my original data is much longer than this, so the performance lag is considerable, not to mention I'm not able to display certain visualisation due to resource maxing out.
I'm hoping for a dax solution that have the same effect as creating the Merged table in the pbix attached without having to duplicate the table and use too many calculated columns.