Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Have the Date column and the values are there for 3 years ie:
01/30/2013
02/28/2013
03/31/2013
04/30/2013
05/31/2013
06/30/2013
07/31/2013
08/31/2013
09/30/2013
10/31/2013
11/30/2013
12/31/2013 and so on...
i need to show in the chart the month end date for eg:- (03/31/2013,06/30/2013,09/30/2013,12/31/2013 and so on).
Can any one help me on this..
Try something like this for a dimension:
=if(num(month([MonthField]))<=3, '3/31/2013',
if(num(month([MonthField]))<=6, '6/30/2013',
if(num(month([MonthField]))<=9, '9/30/2013',
'12/31/2013')))
Or better and more efficient, create a field based on the return value of this if statement in your script
Use the QuarterEnd function:
=QuarterEnd(DATE)
Hope this helps!
Oooo, like it. I didn't realize the QuarterEnd function existed. This goes down as one of my things learned for today, thank you!
You're welcome!
Hi Ankit,
An additional option is through a formula like this:
=Year(Date)&'_'&Ceil(Month(Date)/3)&'Q';
This is a different option of visualization but is aligned with formula QuarterEnd or QuarterName or QuarterStart.
-JFlorian
Thanks Jeremiah Kurpat it worked!!!! Thanks a lot!!!