Clipping 1 measure in chart to today while letting other measure go out to future dates

Questions & Answers
1

Hello, I have an issue that on the surface should be really easy but in practice is difficult. I have a chart with cumulative issues created and cumulative issues resolved. I would like to chop off the data on the resolved line so that it stops at Today. When I attempt to do that it chops off all data. I would like to see the cumulative issues created and Trend to go out into the future but the issues resolved to stop at today. Is there a way to do this? Below is my current chart.
image

I’d like to see the blue line stop at today.

2

Follow this example: https://eazybi.com/accounts/1000/cubes/Issues/reports/139130-open-issues-trend

You are looking at this measure:

image
image.png814×467 21.9 KB

2 Likes
3

Thank you. That worked perfectly for me. My calculated member now looks like this…

CASE WHEN
DateCompare(
[Time].CurrentHierarchyMember.StartDate,
now()
) < 0
THEN
Cache(
Sum({PreviousPeriods([Time].CurrentHierarchyMember),
[Time].CurrentHierarchyMember},
[Measures].[Issues resolved]
)
)
END