Forum Discussion
Portfolio Model
- 6 years ago
You need to have a Portfolio Table and Portfolio Details table to capture portfolio information, then you will need to have a benchmark and benchmark details table for Benchmark and then you need to find a way to link your Porftolio record with a corresponding benchmark record so you know which porfolios use what for benchmark.
this would be easiest, if i understand your problem correctly.. you could potentially have it all in two tables, summary and detail, but then you will need to have a flag in summary table to specify whehter it's a portfolio or benchmarck, and then add another column for benchmark ID, so you can link portfoloio data with benchmark data. but that woud make DAX to do analysis a little bit more complicated.
I would combine it as you've shown. That way, assuming you have a 1:Many from Stocks to Portfolios, you can have a measure like
Portfolio Value = SUMX(Portfolio, Portfolio[Percent] * RELATED(Stocks[Value]))
or something like that to compare portfolios.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat