Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
I need a measure that calculate my portfolio total value for each date (without date gaps).
I'm trying to modeling a next algorytm
Balance 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
Solved! Go to Solution.
@v-shex-msft., thanks!
The problem was in the data model and my lack of understanding of some DAX functions
So the topic is closed.
Hi @lnz,
Can you please share some sample data for test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
@v-shex-msft., thanks!
The problem was in the data model and my lack of understanding of some DAX functions
So the topic is closed.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |