Forum Discussion
Plot a graph between two dates
maxduff59 if you will create a measure like:
MEASURE =
VAR _x_days_before_date = [Your Date x days before Measure]
VAR _date = [your the date of the day Measure]
RETURN
CALCULATE([Your value], DATESBETWEEN('Date Table'[Date], _x_days_before_date, _date]
You would get the y values only for those dates, everything outside will be blank and not presented on the chart and axis will start from your desired start to end.
Thanks for the explications, I just don't understand which term do I need to put first in the CALCULATE function...
you put there an aggregation expression ususally, and you can also call a measure instead. The think I meant that in this case you can't use a var before it and call it inside. But I think the video explains it better.
Let me know that is what you meant.