The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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.
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |