No announcements

Smart Year Ranges - Group By YEARS, Min/Max Combination

; groups that cover together the range between the min year to the max year. For example if the min year is X ...
| 25 Replies | 947 Views | Created by 1brandeja5 - Monday, September 9, 2019 8:18 PM | Last reply by 1brandeja5 - Monday, September 16, 2019 6:08 PM

concatenate consecutive rows with min and max year

Select Id,Year1,Max(Year2)Year2 From RecCte Group By Id,Year1 Please have look on the comment
| 4 Replies | 1208 Views | Created by wael.kader - Monday, March 25, 2013 3:35 PM | Last reply by Santhosh H - Tuesday, March 26, 2013 11:10 AM

max by year

I could but found the answer.  The issue was that I had too much in my group by even though i wasn't using the fields on the report (in the select statement) I for some untold reason was ...
| 2 Replies | 4142 Views | Created by Jag5x5 - Thursday, February 21, 2008 7:53 PM | Last reply by Hunchback - Thursday, February 21, 2008 7:57 PM

Obtain MAX value from a range of years

. Then you can create a measure get the max value between the three ...
| 2 Replies | 430 Views | Created by DaxLearner - Thursday, March 30, 2017 9:25 AM | Last reply by Angelia Zhang - Friday, March 31, 2017 2:52 AM

Find Range Of years

Thank you Dear peso but i want to know how many teachers have an age between a range . (Like group By) i means , when i run the function , it ...
| 3 Replies | 3358 Views | Created by Mansourweb - Saturday, August 15, 2009 9:52 AM | Last reply by K H Tan - Saturday, August 15, 2009 1:43 PM

SQL QUERY FOR MAX SALES AND MIN SALES FOR EVERY YEAR WITH DATE

END) MaxTotalSale, MAX(CASE WHEN RN2=1 THEN SalesDate END) MaxSalesDate, MAX(CASE WHEN RN1=1 THEN TAXABLESALES + NONTAXABLESALES END) MinTotalSale, ...
| 5 Replies | 2335 Views | Created by MALAV PATEL - Friday, September 11, 2015 7:47 AM | Last reply by Naomi N - Sunday, September 13, 2015 2:27 AM

calculating YTD of previous year with max month of this year

if I'm viewing at the quarter level, it's showing my sales for the entire quarter last year. I want it to find out what the max month is for the current period and display the YTD ...
| 7 Replies | 3697 Views | Created by k1ng87 - Thursday, February 23, 2012 8:40 PM | Last reply by k1ng87 - Tuesday, February 28, 2012 3:45 PM

SELECT MAX() Year?

Then you try this: SELECT c.CustomerID, c.YearID, y.YearText FROM Customers c INNER JOIN Years y ON y.YearID = ...
| 14 Replies | 6577 Views | Created by Westside2008 - Thursday, May 31, 2012 6:14 AM | Last reply by Erland Sommarskog - Saturday, June 2, 2012 9:53 AM

Custom field - Split the duration per year, no min max formula?

for each year 2016, 2018, 2019. While this is easy in excel with a Min, Max function I can*t find a way in MS Project. So far I can only get the whole duration ...
| 9 Replies | 997 Views | Created by TobiOneQ - Saturday, February 13, 2016 5:42 AM | Last reply by TobiOneQ - Friday, February 19, 2016 8:23 AM

Get max quarter of a year MDX

Hi Alejandro, According to your description, you want to get the max quarter of current year and the last quarter of last year. ...
| 2 Replies | 533 Views | Created by Alejandro_Zuleta - Tuesday, August 18, 2015 10:06 PM | Last reply by Simon_Hou - Wednesday, August 19, 2015 4:35 AM

SELECT Year Range

Hi,  Try following query: declare @sy int, @currentyear int set @sy = 2006 set @currentyear = DATEPART(year, ...
| 5 Replies | 4388 Views | Created by oasisaplus - Thursday, April 1, 2010 10:33 PM | Last reply by KiranKumar.Y - Friday, April 2, 2010 10:35 AM

GETDATE.In a combination of year and month

use mm, instead of yy then I will get the result in months.   But I want to dislay the result as a combination of year and month, ...
| 11 Replies | 4988 Views | Created by vineethmnair - Friday, March 7, 2008 5:17 AM | Last reply by vineethmnair - Friday, March 7, 2008 9:26 AM

Use a Datatype with longer year range

but for the columns whose year ranges were before 1700 it had error Exactly year 1753, that's the lower limit for the SQL
| 3 Replies | 627 Views | Created by reza nbd - Thursday, November 21, 2013 5:16 PM | Last reply by Mike Yin - Monday, November 25, 2013 10:02 AM

Year to Year %

(Profit),0) as Profit, MIN(Source) as Source from DataTable GROUP BY ID, [Year]) select c1.ID, c1.Sales, c1.Profit, c1.Source, ...
| 10 Replies | 906 Views | Created by shimam - Friday, September 9, 2016 9:38 PM | Last reply by Naomi N - Monday, September 19, 2016 6:27 PM

Return distinct years and row_number for a range

I've got a table who one of the columns is "year" and I want to select the distinct year and row number for a range of rows. I thought
| 3 Replies | 4764 Views | Created by LiteWait - Wednesday, September 10, 2008 1:34 PM | Last reply by Kalman Toth - Wednesday, September 10, 2008 2:06 PM

Min/Max vaule between date range

is only finding the min value based on the group by oppose to the combination of group by and date range. I am looking for the ...
| 3 Replies | 4313 Views | Created by jrobinsontx - Thursday, September 6, 2012 8:04 PM | Last reply by jrobinsontx - Friday, September 7, 2012 1:45 PM

Year to Year changes Group Subtotal

Hi, You need to use the first table as the dataset, adding row group based on Region and Country.  For the SubTotal, using expression like  ...
| 1 Replies | 262 Views | Created by shimam - Wednesday, January 31, 2018 1:58 AM | Last reply by Henry Jiang - Thursday, February 1, 2018 2:49 AM

Display Max and Min value in Range Chart

SSRS 2008, Does anyone know how to display both Min and Max Values as data Labels in Range Chart Thank you.
| 2 Replies | 5983 Views | Created by Pentium NY - Sunday, March 21, 2010 6:47 AM | Last reply by Eswararao C - Tuesday, March 23, 2010 4:54 AM