Skip to Content
Former Member
Nov 17, 2015 at 01:03 PM

How to display the first monday of a quarter ?


Good morning everyone,

I am a new user of Webi and I am searching a formula to display the complete date of the first Monday of the quarter.

I am currently using this method :

  • 1st Day Conf Quarter =ToDate(("01/" + (ToNumber(Right([Quarter];2))*3-2) +"/" + Left([Quarter];4));"DD/MM/YYYY")
  • 1st Monday Conf Quarter =RelativeDate(LastDayOfWeek([1st Day Conf Quarter]);-6)

Quarter is a characteristic from my BI query I use to obtain the month and the year, it is not a calculated key figure.

This method is not available because in some case, it gave me the Monday of the previous quarter. This is the case for the 4th quarter 2015, it gives me Monday September 28th.

Could you please explain me what kind of method should I use to obtain the correct data ?

Thank you in advance.