Forum Discussion
Line Chart with Multiple Values Starting from $100 USD (Calculated from portfolio's Start Month)
Then you will need to use a disconnected Calendar table and modify the measure slightly.
Measure = var md = max('Calendar'[Date]) var mn = max(Master[Name]) var mnd = minx(filter(Data,[Name]=mn),[Date]) return if(edate(mnd,-1)=md,100, 100*productx(filter(allselected(Data),[Name]=mn && [Date]<=md),1+[Mothly Return (%)]/100))
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi lbendlin
Thanks for looking at the question!
Wondering if the sample has been provided is not enough, or is it not able to be accessed?
Sample: Sample Power Bi & Raw Data
You may be overcomplicating this a little? Do you really need to add the initial "100" value? What do you mean by "umbrella" ?
Hi lbendlin,
Sorry for confusing you, the umbrella represents the outcome's look.
We like to have them all start from 100, to analysis and compare the performance of them, and for people easily understand how it is, sometimes, will use Usd 1,000 instead.
Here are some application examples.
Then you will need to use a disconnected Calendar table and modify the measure slightly.
Measure = var md = max('Calendar'[Date]) var mn = max(Master[Name]) var mnd = minx(filter(Data,[Name]=mn),[Date]) return if(edate(mnd,-1)=md,100, 100*productx(filter(allselected(Data),[Name]=mn && [Date]<=md),1+[Mothly Return (%)]/100))