I have next assets portfolio transactions table:
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] )
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
Dev Report Screenshot
Go to Solution.
@v-shex-msft., thanks!The problem was in the data model and my lack of understanding of some DAX functionsSo the topic is closed.
View solution in original post
Can you please share some sample data for test?
How to Get Your Question Answered Quickly
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!