No announcements

### Weekly grouping gets split at year 2015 end in SSRS Report

with 52 weeks and some with 53 weekTo Further explore it I found that year starting with Thursday are having 53 weeks and the leap years starting with Wednesday ...
| 2 Replies | 574 Views | Created by Karim El Zarka - Friday, February 19, 2016 9:24 AM | Last reply by DipuTheLearner - Tuesday, March 8, 2016 9:04 AM

### SSAS MDX Calculations - Time intelligence puzzle. (53 week year)

don't think the additional attribute will resolve my issue. Week 53 is to be included in the analysis, as this would map to week 52 of the following year, its ...
| 7 Replies | 6550 Views | Created by GS80 - Tuesday, February 10, 2009 8:37 PM | Last reply by Martina White - Wednesday, February 15, 2012 7:57 PM

### SQL Query for last week / previous week data

ww</g> are the number of the week within the year (01 to 52 or 53), the – is a separator and the day within the week number starts ...
| 4 Replies | 3788 Views | Created by Alex Varghese - Monday, December 10, 2018 6:02 AM | Last reply by --CELKO-- - Monday, December 10, 2018 9:35 PM

### Counting week over week

The problem is that it is aggregating per week, but cumulatively week over . If you look at the initial post, the result I am seeking is explained, I need t count Wk 1 ...
| 2 Replies | 3397 Views | Created by RonInOttawa - Sunday, October 11, 2009 11:32 AM | Last reply by RonInOttawa - Monday, October 12, 2009 12:01 AM

### Doubled values on X-axis

;2011        132 2      2011        135 Obviously there is week number 51, 52 and ...
| 1 Replies | 4436 Views | Created by petka - Friday, September 2, 2011 2:36 PM | Last reply by petka - Monday, September 26, 2011 7:51 PM

### Get and display the current week number of the year

Sunday and would therefore be week #53. Is that right? I thought there was only supposed to be 52 weeks in a year... If anyone can forsee a problem please let me know, ...
| 5 Replies | 5800 Views | Created by programmer4life - Thursday, March 1, 2007 4:07 AM | Last reply by Dave299 - Thursday, March 1, 2007 5:39 PM

### Add column with start date in week format (1,2,3...52)

Then the start and finish dates will be displayed with the week number and day of the week (ie 6 for friday).
| 3 Replies | 8817 Views | Created by Enrique Nrv - Friday, June 20, 2014 4:30 PM | Last reply by Guillaume Rouyre [MBA, MVP, MCC] - Friday, June 20, 2014 4:50 PM

### how to handle 53 rd week in sql server

Hi Team, How can we move extra days which are falling into 53 rd week to be treat as the 52nd week in sql server for date ...
| 3 Replies | 613 Views | Created by harshavatsa - Monday, February 4, 2019 10:20 AM | Last reply by Will_Kong - Tuesday, February 5, 2019 6:52 AM

### Calculate Week over week

So the column WeekID should have the values from 1 to 52 for each name, correct?A Fan of SSIS, SSRS and SSAS
| 7 Replies | 1011 Views | Created by Victory5 - Tuesday, May 14, 2019 11:35 PM | Last reply by Guoxiong Yuan - Wednesday, May 15, 2019 9:36 PM

### Start week of the month for a given week

the week in that month (1 to 4 or 1 to 5), I need return a number 1 to 52 or 53 but been the first week of the month of a given ...
| 33 Replies | 1195 Views | Created by Jamesit0 - Thursday, July 23, 2015 5:10 PM | Last reply by --CELKO-- - Friday, July 24, 2015 4:25 PM

### How to get last week, 2nd last week, 3rd week etc from time(week) dimension?

]) or ([Date].[Calendar].[week].Currentmember.Lag(1) ,[Measures].[Sales]) Like this you can change for last 2 weeks ...
| 2 Replies | 2701 Views | Created by sriven14 - Thursday, December 8, 2011 5:47 AM | Last reply by sriven14 - Thursday, December 8, 2011 6:53 AM

### Remove Weeks 53 from ISO Year/Week structure in query

succeed in limiting the data that is fetched by the calculated members. They look outside of the standard slicer (so a subquery with -[Date].[Week].&[53] will not work), and ...
| 2 Replies | 3907 Views | Created by tss68nl - Monday, January 11, 2010 9:34 PM | Last reply by tss68nl - Tuesday, January 12, 2010 10:21 AM

### annual Work Week numbers in Top Level of timescale

That's the current setup.   The weeks continue to increment at the end of the year 51, 52, 53, 54 etc.   I need this to stop at the end of the ...
| 4 Replies | 12372 Views | Created by IndyRobotEng - Saturday, August 20, 2011 4:29 AM | Last reply by Achod G - Wednesday, October 26, 2011 12:15 AM

### DatePart(Week, @Date) Returns wrong weeknumber?

has 52 or 53 full weeks (364 or 371 days). The extra week is here called a leap week (ISO 8601 does not use the ...
| 10 Replies | 34662 Views | Created by Josje - Monday, January 11, 2010 8:08 AM | Last reply by Igor Gelin - Thursday, October 18, 2012 12:48 PM

### Get the enddate of last week?

next two digits are the week within year, numbered from 01 to 52 or 53. The final digit is the day within ...
| 4 Replies | 517 Views | Created by larraw - Tuesday, May 24, 2016 7:24 AM | Last reply by --CELKO-- - Monday, June 6, 2016 2:16 AM

### ParallelPeriod for week over week

In that case, here's a sample Adventure Works query which computes [PrevWeekSales] by finding the previous date of the same [Day of ...
| 5 Replies | 5164 Views | Created by Javier Guillen - Tuesday, May 25, 2010 1:47 PM | Last reply by Javier Guillen - Wednesday, May 26, 2010 12:26 PM

### Getting This week and last week data

However, it's still not giving me the right result set. Today is week 30 of the year. The result should be weeks 27-30 not 50-53. Also, what will happen if we run ...
| 9 Replies | 2062 Views | Created by Mike-007 - Tuesday, July 23, 2013 7:48 PM | Last reply by Mike-007 - Wednesday, July 24, 2013 3:34 PM

### Get previous 52 weeks (12 months) by week

through previous 52 week .. in that a week means calendar week or week from a random date input ? A calendar table like
| 7 Replies | 788 Views | Created by MacBaze72 - Thursday, July 12, 2018 2:08 PM | Last reply by SQLNeophyte - Friday, July 13, 2018 5:42 AM