Forum Discussion
Calculate portfolio value per asset
I have next assets portfolio transactions table:
| DATE | ASSET-ID | ASSET-NAME | AMOUNT | BALANCE |
| 21.04.2016 | 2 | FB | 300 | 300 |
| 01.07.2016 | 1 | AAPL | 500 | 500 |
| 10.02.2017 | 1 | AAPL | 100 | 600 |
| 15.05.2017 | 1 | AAPL | 250 | 850 |
Also I have:
- Calendar table (universal DateDim)
- Stock table (stock prices table with DATE, ASSET-ID, PRICE columns). So I have one PRICE column for all assets.
- [Stoсk Price CUR] measure that calculate actual stock price without data gaps
I need a measure that calculate my portfolio total value for each date (without date gaps).
I'm trying to modeling a next algorytm
- Calculate actual balance for each asset [measure]
Here I use LASTNONBLANK formulaBalance WoG = VAR d = SELECTEDVALUE ( 'Calendar'[Date] ) RETURN CALCULATE ( LASTNONBLANK(split[end-balance];1); split[Date] <= d; CROSSFILTER ( 'Calendar'[Date]; split[date]; NONE ) )
2. Calculate actual value for each asset [measure]
Here I'm trying to use that formula:
Asset Value =
CALCULATE([Balance WoG]*[Stock Price CUR])
That works fine only then I use asset-id as Legend on my chart (see screenshot), but I inderstand, that I need something more savvy
3. Sum all assets value [measure]
Can't understand how to solve it
- Anonymous7 years ago
Anonymous., thanks!
The problem was in the data model and my lack of understanding of some DAX functions
So the topic is closed.
2 Replies
- AnonymousNot applicable
Hi Anonymous,
Can you please share some sample data for test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
- AnonymousNot applicable
Anonymous., thanks!
The problem was in the data model and my lack of understanding of some DAX functions
So the topic is closed.