5 Replies Latest reply: May 2, 2017 8:20 AM by Gustavo Soares

# Dimension (actual month till end of year)

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.

• ###### Re: Dimension (actual month till end of year)

YTD, MTD issue

Example:

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

• ###### Re: Dimension (actual month till end of year)

I wroted:

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

but the result was the following, why?:

• ###### Re: Dimension (actual month till end of year)

Maybe ?

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

• ###### Re: Dimension (actual month till end of year)

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

• ###### Re: Dimension (actual month till end of year)

Tente essa: Month(Data Prevista) > = 4