I want an expression at my dimension that gives only the acual month visible till the last month of this year.
Example: in this Line Chart i want April to december 2017, despite march values.
Please refer to this thread :
Example:
sum({<date=,Year=,Month=,Quarter=, date={">=$(=Max(date)) <=$(=YearEnd(Max(date)))"}>}Sales)
I wroted:
sum({<[Date.autoCalendar.Year], Date={">=$(=Max(date)) <=$(=YearEnd(Max(date)))"}>}[Vsales])
but the result was the following, why?:
Maybe ?
sum({<[Date.autoCalendar.Year]=,[Date.autoCalendar.Month]=,[Date.autoCalendar.Date]=,[Date.autoCalendar.Date]={">=$(=Max([Date.autoCalendar.Date])) <=$(=YearEnd(Max([Date.autoCalendar.Date])))"}>}[Vsales])
Sorry but i don´t have the resul i want.
My measure is for YEAR 2017:
Sum({<[Date receita.autoCalendar.Year] = {'$(=Year(Today()))'}>} [sales])
But the months before april keep on showing in the chart. After reading your explanations i have to include => actual Month Similar to:
Sum({<[Date receita.autoCalendar.Year] =, [Date receita.autoCalendar.month] =, {">=$(=Max([Date.autoCalendar.Date])) =$(='$(=Year(Today()))"} >[sales])
But this expression don´t work
