No announcements
Found 1944914 threads
-
1 VotesYTD to stop at
Hi AlexMartini, DATESYTD Function returns a table that contains a column of the dates for the year to date, in the current context.Answered | 1 Replies | 800 Views | Created by AlexMartini - Wednesday, November 2, 2016 11:08 PM | Last reply by Angelia Zhang - Thursday, November 3, 2016 10:46 AM
-
0 Votes
YTD and other time calculations across all measures
Client wants to see a YTD option for all measures.Answered | 1 Replies | 2124 Views | Created by Jacky Chau - Monday, October 29, 2012 2:13 PM | Last reply by Martin Mason - Monday, October 29, 2012 4:52 PM -
0 Votes
YTD calculations problem
The measure below doesn't seem to calculate them ...Answered | 4 Replies | 1372 Views | Created by RealFlyfishII - Thursday, May 29, 2014 9:37 AM | Last reply by Marco Russo - SQLBI - Friday, June 13, 2014 12:35 AM -
0 Votes
Trying to calculate YTD till Passed parameter
[Sales Volume] ) For a YTD calculation you might want to consider ...Answered | 3 Replies | 3780 Views | Created by nairgokul - Tuesday, January 12, 2010 12:19 PM | Last reply by Mark Wojciechowicz - Wednesday, January 13, 2010 5:43 PM -
0 Votes
MDX equivalent of DAX YTD measure
[Fiscal Hierarchy].currentmember},Measures.MyMeasure)' There are a myriad of ways to write a YTD calculation.Answered | 8 Replies | 1450 Views | Created by PentAgraMm - Monday, January 15, 2018 1:27 AM | Last reply by RichardLees - Tuesday, January 23, 2018 5:14 AM -
4 Votes
how to calculate MTD, QTD and YTD
A useful idiom is a report period calendar.Answered | 7 Replies | 24735 Views | Created by Bihon noro - Monday, October 29, 2018 4:52 PM | Last reply by Rachel_Wang - Tuesday, October 30, 2018 1:46 AM -
0 Votes
YTD named set and current year
2- How can I obtain the current year with a named set.Answered | 2 Replies | 4284 Views | Created by Rouxyman - Thursday, November 19, 2009 7:36 AM | Last reply by Raymond-Lee - Monday, November 23, 2009 6:23 AM -
0 Votes
How to calculate the YTD of a column
Here are other methods for versions before 2012: - A cursor - A SQLCLR function - A correlated ...Answered | 2 Replies | 2682 Views | Created by nmittapalli - Wednesday, April 18, 2012 3:30 PM | Last reply by Hunchback - Wednesday, April 18, 2012 3:42 PM -
2 Votes
lots of years and then YTD
When you have new data everyday, you could simply calculate the total for the whole year and then for the current year, it will obviously calculate the YTD (as ...Answered | 4 Replies | 1177 Views | Created by AlexMartini - Wednesday, December 21, 2016 9:38 PM | Last reply by Imke Feldmann - Sunday, January 15, 2017 7:07 AM -
0 Votes
Using YTD function with Fiscal Year
I just think it is ridiculous that SSAS doesn't recognize FiscalYears as a YEAR level.Answered | 2 Replies | 5498 Views | Created by Frank Kearney - Monday, April 13, 2009 6:04 PM | Last reply by Frank Kearney - Tuesday, April 14, 2009 4:03 PM -
0 Votes
ytd date calculation mdx ssas
i am trying to compare the measure value for the current year to date with the prior year to date.Answered | 3 Replies | 3667 Views | Created by neophytenik - Thursday, August 2, 2012 8:55 PM | Last reply by neophytenik - Monday, August 6, 2012 5:57 PM -
0 Votes
One universal YTD calc/set for all measures
in addition to chistopher's answer, let me point out that a YTD calculation is not usually what you wrote here. if you want just the last 15 months in the database, you can also ...Answered | 6 Replies | 2296 Views | Created by Lars Koewing - Friday, March 1, 2013 8:45 PM | Last reply by Lars Koewing - Monday, March 4, 2013 8:11 PM -
0 Votes
How calculating YTD measure with a time dimension
You should be able to create a calculated measure on the fact table using TOTALYTD like this: TOTALYTD ( SUM ( ...Answered | 1 Replies | 4523 Views | Created by pscorca - Wednesday, December 7, 2011 5:57 PM | Last reply by Brent Greenwood - Thursday, December 8, 2011 3:48 PM -
0 Votes
YTD values with two time hierarchies in SSAS
[Internet Sales Amount YTD] as Aggregate ( YTD ( Tail( {existing [Date].Answered | 4 Replies | 7376 Views | Created by Sunny Dagliya - Thursday, April 7, 2011 1:31 PM | Last reply by Rannsri - Wednesday, April 13, 2011 11:20 PM -
0 Votes
Calculating YTD Average Balances using exsiting column "MTD Average Balance"
It is not necessary to create "EndOfMonth" Table , we can just use Dates and Sales table to achieve this: Create a measure ...Answered | 13 Replies | 3508 Views | Created by Jeannette_81 - Wednesday, April 4, 2018 2:49 PM | Last reply by Jeannette_81 - Thursday, April 12, 2018 4:02 PM -
0 Votes
MTD and YTD Query help
Since SQL is a database language, we prefer to do look ups and not calculations.Answered | 2 Replies | 2176 Views | Created by Farhan1 - Monday, February 4, 2013 9:18 PM | Last reply by --CELKO-- - Friday, March 29, 2013 8:02 PM -
0 Votes
ytd counts based on different groupings in same dataset
>I'd like to create a view that has a ytd count of these records [sic: rows are not records] for manager in one new column, a ytd count for worker within this manager in another ...Answered | 4 Replies | 835 Views | Created by db042190 - Wednesday, September 28, 2016 8:32 PM | Last reply by --CELKO-- - Thursday, September 29, 2016 2:05 PM -
0 Votes
YTD Query Question
[Total Submissions]} ON COLUMNS, NON EMPTY{[YTD] , [YTD-1], [YTD-2], [YTD-3], [YTD-4]} * {[Plan].Answered | 2 Replies | 5437 Views | Created by aus_col - Monday, May 2, 2011 5:40 AM | Last reply by aus_col - Tuesday, May 3, 2011 2:12 AM -
1 Votes
YTD that cuts dates off
In your case, you probably want a measure like: Sales YTD = IF ( MIN ( ...Answered | 1 Replies | 875 Views | Created by AlexMartini - Wednesday, November 16, 2016 6:18 PM | Last reply by Owen Auger - Wednesday, November 16, 2016 10:30 PM -
0 Votes
Get the last YTD for several selected months?
" - one approach that may work uses a many-to-many model, with an intermediate Current<-->YTD table.Answered | 8 Replies | 4283 Views | Created by Göran Karlsson - Tuesday, August 11, 2009 3:29 PM | Last reply by Göran Karlsson - Thursday, August 13, 2009 6:57 AM
No announcements
