Dimension (actual month till end of year)

[#1]

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.

[OmarBenSalem · Accepted solution]

Please refer to this thread :

YTD, MTD issue

Example:

sum({<date=,Year=,Month=,Quarter=, date={">=$(=Max(date)) <=$(=YearEnd(Max(date)))"}>}Sales)

[#3]

I wroted:

sum({<[Date.autoCalendar.Year], Date={">=$(=Max(date)) <=$(=YearEnd(Max(date)))"}>}[Vsales])

but the result was the following, why?:

[OmarBenSalem]

Maybe ?

sum({<[Date.autoCalendar.Year]=,[Date.autoCalendar.Month]=,[Date.autoCalendar.Date]=,[Date.autoCalendar.Date]={">=$(=Max([Date.autoCalendar.Date])) <=$(=YearEnd(Max([Date.autoCalendar.Date])))"}>}[Vsales])

[#5]

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

[#6]

Tente essa: Month(Data Prevista) > = 4