Week number in month

[#1]

Hi ALL,

i have this calendar srcipt:

Load

  Date as Date,

  Month(Date) as Month,

  Year(Date) as Year,

  Week(Date) as Week,

  WeekDay(Date) as WeekDay,

  Day(Date) as Day,

  'Q'&Ceil(Month(Date)/3) as Quarter,

  'H'&Ceil(Month(Date)/6) as HalfYear,

  MonthName(Date) as YearMonth,

  Year(Date) &'-Q'& Ceil(Month(Date)/3) as YearQuarter,

  Year(Date) &'-H'& Ceil(Month(Date)/6) as YearHalfYear

resident Temp;

And when i put week as dimension , i can see only week number. I want to see Year, mont name and week number of month(for example, when i select  2014 year and Mar month i see only week numbers(see atch), my expected result is 2014 Mar 1, 2014 Mar 2,2014 Mar 3,2014 Mar 4  .  How can i modifie calendar scrip? Please help

[#2 · Accepted solution]

Use this,

  Year(Date)&' '&Month(Date)&' '&Ceil(Day(Date)/7) as WeekNoofMonth

Thanks,

Prabhu

[#3]

Thanks!!!