YTD in line graph

[Patrick Nishiyama]

Hello,

I am a few days trying to make an accumulated until the current month, but the line of the graph is in the whole year. Is there a way to condition this expression Is it possible to obtain the X-axis label to create a condition

 

My current expression:

Sum(If([status]="REAL",1,0)) THEN Sum([Value]) OVER (AllPrevious([Axis.X])) as [Real.]

Thanks

[Fabian Duerr]

You can probably wrap all this into an IF or CASE function where you return your value/expression when the date <= current date, else return NA.

 

Please put some sample data here if you need more help.