Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |