Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get the month start date for eg:11/01/2012 from a date field?
i am trying to do a MTD trend.
this is the way i got it worked
sum({ <[Received Date]={">=$(=monthstart(date(max([Received Date]))) )<=$(=monthend(date(max([Received Date]))))"}> }[Loan Counter])
=monthstart(yourdatefield) should work?
yes that does work is there any way that i could use this and write monthtodate wherein i need the show a trend
eg:
start date:11/01/2012
end date:11/27/2012
do a trend showing all the values, how can i do that?
if(month(today())&year(today())=month(Date)&Year(Date),1,0) As MTD_FLAG
yes that does work is there any way that i could use this and write monthtodate wherein i need the show a trend
eg:
start date:11/01/2012
end date:11/27/2012
do a trend showing all the values, how can i do that?
HI,
Create a variable for start and end dates like below
vStartDate = MonthStart(Max(DateDimension))
vEndDate = If(MonthName(Max(DateDimension)) = MonthName(Today()), Today(), MonthEnd(Max(DateDimension)))
Now use this variables in expression
=Sum({<DateDimension = {'>=$(=vStartDate)<=$(=vEndDate'}>} Sales)
Hope this helps you.
Regards,
Jagan.
Hi,
Are you talking about daily sales trend for a month? Add below condition in your exression and use the date field as a dimension.
monthstart(datefield)=monthstart(today())
Thx,
Satya
Yes i need to show consecutive daily month trend where datefiled range is from
month starting to current date.(eg:11/01/2012 to11/28/2012) each every day count(orders).
this is the way i got it worked
sum({ <[Received Date]={">=$(=monthstart(date(max([Received Date]))) )<=$(=monthend(date(max([Received Date]))))"}> }[Loan Counter])