No announcements
Found 1808496 threads
-
1 VotesWeekly 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 ...Answered | 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
-
0 Votes
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 ...Unanswered | 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 -
0 Votes
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 ...Answered | 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 -
0 Votes
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 ...Unanswered | 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 -
0 Votes
Doubled values on X-axis
;2011 132 2 2011 135 Obviously there is week number 51, 52 and ...Answered | 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 -
0 Votes
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, ...Answered | 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 -
0 Votes
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).Unanswered | 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 -
0 Votes
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 ...Unanswered | 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 -
1 Votes
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 SSASAnswered | 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 -
6 Votes
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 ...Answered | 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 -
0 Votes
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 ...Answered | 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 -
0 Votes
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 ...Answered | 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 -
2 Votes
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 ...Answered | 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 -
5 Votes
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 ...Answered | 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 -
0 Votes
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 ...Answered | 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 -
1 Votes
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 ...Answered | 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 -
1 Votes
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 ...Unanswered | 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 -
0 Votes
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 likeProposed | 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 -
1 Votes
Group By Week Query
yyyy</g> is the year, the W is punctuation, xx is the week within the year, starting at 01 thru 52 or 53 (depends on the year), the – is punctuation and ...Proposed | 6 Replies | 810 Views | Created by Shayaan - Tuesday, November 20, 2018 4:32 PM | Last reply by Will_Kong - Wednesday, November 21, 2018 1:55 AM -
0 Votes
Selecting last 52 weeks of data
=DATEADD(week,-53,@Last_Week_Date) AND CalendarDate<=DATEADD(week,-52,@Last_Week_Date)Answered | 11 Replies | 11603 Views | Created by LZee - Friday, February 12, 2010 4:04 PM | Last reply by - Friday, January 14, 2011 7:33 AM
No announcements
