Forum Discussion
Cumulative Line Target in Chart
I am tying to make a cumulative line target appear in the chart. The line must start with the value given by the measure and then it gets added by itself for each day. For example: if the target valu...
Hi Anonymous ,
Make sure the start measure always returns static value for each day.
Then rank the days on x-axis and multiply by [measure].
Cumulative_Target = [Measure]*RANKX(ALLSELECTED(Date_Table),CALCULATE(SELECTEDVALUE(Date_Table[day])),,ASC)Best Regards,
Jay
Hi Anonymous ,
Make sure the start measure always returns static value for each day.
Then rank the days on x-axis and multiply by [measure].
Cumulative_Target = [Measure]*RANKX(ALLSELECTED(Date_Table),CALCULATE(SELECTEDVALUE(Date_Table[day])),,ASC)
Best Regards,
Jay