On the chart level is necessary to create a synthetic dimension (by field "Date", the downloaded Date is not). Functions ValueList() and ValueLoop() as arguments accept only constants. It is not possible to create a dimension "date"calculated by.
As an option, exit out of this situation as follows. Likely the master calendar is loaded during download script. It is possible to include the field start of the month as a standard date. Example,
MonthStart(MakeDate(Year(Left([Period], 10)),Month(Left([Period], 10)))) as CalendarFistMonthDay
This allows the field "CalendarFistMonthDay" is the master calendar used as dimension in our diagram.
As an option, expression of the chart could look like this
If(CalendarFistMonthDay <= Max(DateS), Sum(Value), 25 + 5*(Month(CalendarFistMonthDay)-4))
An example can be found in the attached file.
Alternatively, if you have downloaded the date field, the line chart can be obtained by dimension
If(Only(MonthStart([%Date])) <= Max(DateS), Sum(Value), 25 + 5*(Month(Only(MonthStart([%Date])))-4))
The file as an attachment, Sheet2
Thanks for taking time and looking into my question.
The solution you are suggesting helped me partially.
I am running into issue because I want to use $(Test) as base value and $(M7) as increment value but when I use these variables in chart or table they are giving different values based on Year Month as dimension.
But what I am trying to do is get $(Test) = 544421.33 assign it to April 01, 2016 then for rest of the months it should be 544421.33 + $(M7) where $(M7) = -17731.74.
Please refer to screenshot below.
Any suggestion to resolve this issue is highly appreciated.