Question on limiting time series chart measure

[Anonymous]

Hi all

I'm trying to create a measure that limits how much of a time series is shown... I want it to stop at a certain date which below I have set manually as 31/08/2017.. I'll make this programmatic later but for now I want it to limit how much of the measure "YoY Sales CIQ" is shown based on that limit..

I get the following error message below saying the single value of the Period column cannot be determined

Any ideas are greatly appreciated

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may simply add a MAX Function.