Patrick Nishiyama Posted February 18, 2021 Share Posted February 18, 2021 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 Link to comment Share on other sites More sharing options...
Fabian Duerr Posted February 18, 2021 Share Posted February 18, 2021 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now