Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Absalon29,
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
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |