No announcements

YTD 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.
| 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

YTD and other time calculations across all measures

Client wants to see a YTD option for all measures.
| 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

YTD calculations problem

The measure below doesn't seem to calculate them ...
| 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

Trying to calculate YTD till Passed parameter

[Sales Volume]               ) For a YTD calculation you might want to consider ...
| 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

MDX equivalent of DAX YTD measure

[Fiscal Hierarchy].currentmember},Measures.MyMeasure)' There are a myriad of ways to write a YTD calculation.
| 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

how to calculate MTD, QTD and YTD

A useful idiom is a report period calendar.
| 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

YTD named set and current year

2- How can I obtain the current year with a named set.
| 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

How to calculate the YTD of a column

Here are other methods for versions before 2012: - A cursor - A SQLCLR function - A correlated ...
| 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

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 ...
| 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

Using YTD function with Fiscal Year

I just think it is ridiculous that SSAS doesn't recognize FiscalYears as a YEAR level.
| 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

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.
| 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

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 ...
| 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

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 ( ...
| 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

YTD values with two time hierarchies in SSAS

[Internet Sales Amount YTD] as Aggregate ( YTD ( Tail( {existing [Date].
| 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

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 ...
| 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

MTD and YTD Query help

Since SQL is a database language, we prefer to do look ups and not calculations.
| 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

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 ...
| 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

YTD Query Question

[Total Submissions]} ON COLUMNS, NON EMPTY{[YTD] , [YTD-1], [YTD-2], [YTD-3], [YTD-4]} * {[Plan].
| 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