-
Re: Dimension (actual month till end of year)
omar bensalem Apr 28, 2017 6:55 AM (in response to C�mara Municipal de Lisboa)Please refer to this thread :
Example:
sum({<date=,Year=,Month=,Quarter=, date={">=$(=Max(date)) <=$(=YearEnd(Max(date)))"}>}Sales)
-
Re: Dimension (actual month till end of year)
C�mara Municipal de Lisboa Apr 28, 2017 8:45 AM (in response to omar bensalem )-
Re: Dimension (actual month till end of year)
omar bensalem Apr 28, 2017 8:54 AM (in response to C�mara Municipal de Lisboa)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)
C�mara Municipal de Lisboa Apr 28, 2017 9:32 AM (in response to omar bensalem )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)
Gustavo Soares May 2, 2017 8:20 AM (in response to C�mara Municipal de Lisboa)Tente essa: Month(Data Prevista) > = 4