Using columns from two separate models

[Anonymous]

I need to do a simple subtraction using two columns in two separate models (see below) which are related. In GHY Portfolio Data I need to calculate weight for each BAML Industry (the easy bit) and subtract the equivalent weight in HW00 (which is a separate model) so that I can calculate what our relative weight to HW00 index is.  I have tried using Related/Related Table but for some reason I can't get it to work. Ideally we like to be able to then look at the portfolio using GHY Portfolio Data[Country] or other columns in the GHY model. 

[v-yulgu-msft]

Hi @Anonymous,

Maybe you should provide more detailed information like data records and desired result so that I can try to test.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[Anonymous]

Hi Yuliana

Please see attached pbix file 

https://1drv.ms/u/s!AiRs1BCuVWhM9DdsNuAEJUXfWZe7

[Anonymous]

I have cut down the two data sets to make it easier. The GHY Data contains multiple months of data, which I want to filter by BAML Industry and then calculate the weight. The HW00  data is Index data for one month which uses the same industry classification (Sector Level 3) but this data is just recorded for the past month (Month ending 28th Feb 2018). 

https://1drv.ms/x/s!AiRs1BCuVWhM9DV3F0-EN5aOnvnZ