Re: Using columns from two separate models

Anonymous · ‎03-19-2018

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 · ‎03-20-2018

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎03-21-2018

Hi Yuliana

Please see attached pbix file

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

Anonymous · ‎03-20-2018

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