No announcements
Found 1944908 threads
-
1 VotesSSAS Tabular - YTD calculation
Hi, I got exactly same issue, YTD is returning blank.Answered | 16 Replies | 9313 Views | Created by NewMSSAS - Monday, October 7, 2013 10:11 PM | Last reply by Paul Diponkar - Tuesday, April 11, 2017 2:47 PM
-
0 Votes
YTD ending in the Current Period
[Calendar Year].CurrentMember) --the set of all members from the first to the current AGGREGATE(YTD([Date].Answered | 1 Replies | 5293 Views | Created by George.OS - Monday, January 3, 2011 11:38 PM | Last reply by Boyan Penev - Tuesday, January 4, 2011 1:03 AM -
0 Votes
Period YTD - MDX Calculation
[aggr completed month ytd] AS Aggregate([completed month ytd]) SELECT ( [Date].Answered | 3 Replies | 1502 Views | Created by Siva_SSK - Thursday, April 10, 2014 2:47 PM | Last reply by VHteghem_Ph - Friday, April 11, 2014 8:43 PM -
0 Votes
SSAS Calculated Measure YTD using Named Set
[Sales (CDN) YTD] AS Aggregate ( YTD ( Tail(existing [Fiscal Period].Answered | 9 Replies | 13388 Views | Created by uma_s - Thursday, April 7, 2011 7:41 PM | Last reply by Rannsri - Friday, April 15, 2011 4:17 PM -
0 Votes
calculating YTD of previous year with max month of this year
If I'm at the quarter or year level in the hierarchy, it is displaying the YTD value of last year for the same Qtr or year.Answered | 7 Replies | 4193 Views | Created by k1ng87 - Thursday, February 23, 2012 8:40 PM | Last reply by k1ng87 - Tuesday, February 28, 2012 3:45 PM -
1 Votes
YTD calculation for regular dimension
The Aggregate function cannot be used on calculated measures.Answered | 17 Replies | 6586 Views | Created by XLP_Clarion - Monday, April 13, 2009 9:20 AM | Last reply by XLP_Clarion - Thursday, August 27, 2009 7:30 AM -
1 Votes
Calculate YTD and MTD by Period
Please make sure that you create query (view) that aggregate the sales amount per product and per period.Answered | 4 Replies | 23930 Views | Created by Dalton, Mark - Tuesday, April 19, 2011 8:06 PM | Last reply by Abdul Badru - Tuesday, May 13, 2014 10:22 AM -
0 Votes
YTD parallel period
The formula i have will work for [ytd ly] HTH Paul www.paultebraak.wordpress.comAnswered | 3 Replies | 3286 Views | Created by lrj1985 - Tuesday, August 23, 2011 5:05 AM | Last reply by Paul te Braak - Tuesday, August 23, 2011 6:40 AM -
0 Votes
YTD Excluding Current Month
Try using SUM (YTD([Month].Answered | 1 Replies | 5717 Views | Created by Todd C - Tuesday, December 7, 2010 9:01 PM | Last reply by Naveen Das - Tuesday, December 7, 2010 9:33 PM -
0 Votes
Req YTD Calculation Steps
I have create a sample report and calculation using the expression below for you reference.Answered | 2 Replies | 810 Views | Created by Venkataram007 - Saturday, February 27, 2016 11:42 PM | Last reply by Charlie Liao - Monday, February 29, 2016 2:57 AM -
0 Votes
Working Days YTD vs Prior Year
Then I think you could get the same working day last year with an expression like the following SUM( [Date].Answered | 3 Replies | 3086 Views | Created by Todd C - Monday, July 2, 2012 5:54 PM | Last reply by Darren Gosbell - Tuesday, July 3, 2012 4:07 AM -
0 Votes
YTD calculation Fiscal hierarchy
In the YTD() function you need to put in each hierarchy like YTD(MyDateDimension.MyDateHierarchy).Answered | 1 Replies | 2426 Views | Created by schnandr - Wednesday, September 5, 2012 8:50 AM | Last reply by Thomas Ivarsson - Wednesday, September 5, 2012 5:49 PM -
2 Votes
MDX Sum of YTD (returning NULL)
[Measures].YTD_Actual AS sum(YTD([FISCAL PERIOD].Answered | 2 Replies | 3732 Views | Created by Steven David Roberts - Tuesday, March 17, 2015 1:33 PM | Last reply by Venkata Koppula - Friday, March 20, 2015 9:14 AM -
1 Votes
MDX Range function for YTD (SSAS)
[Report], you can just use MDX function YTD to get YTD value.Answered | 2 Replies | 1451 Views | Created by BandSr - Wednesday, March 29, 2017 11:42 AM | Last reply by willson yuan - Thursday, March 30, 2017 2:47 AM -
0 Votes
Calculating YTD Values from financial periods
I'm still struggling with when this is filtered (as YTD will only show the currently filtered month) but it's got me some of the way.Answered | 2 Replies | 1265 Views | Created by daveyboyh - Tuesday, February 4, 2014 9:13 PM | Last reply by daveyboyh - Friday, February 14, 2014 5:50 PM -
0 Votes
One report for current month and YTD figures
As Spark said, you can create a calculated measure in the cube, or in the query which wgives you YTD values.Answered | 6 Replies | 5173 Views | Created by Erik Monchen - Monday, December 13, 2010 9:59 AM | Last reply by Boyan Penev - Tuesday, December 14, 2010 5:18 AM -
0 Votes
YTD, YTD change vs previous YTD on TIME DIMENSION
I don't know if I can define in time dimension an attribute that gives me YTD values, YTD growth for any measure...Answered | 1 Replies | 5307 Views | Created by xgutierrez - Wednesday, March 17, 2010 4:50 PM | Last reply by xgutierrez - Wednesday, March 17, 2010 5:00 PM -
2 Votes
Fiscal YTD and compare Fiscal Period to date
Assuming a date table that contains a list of all dates, a fiscal year for each date, and a fiscal day of year for each date: Orders:= SUM( FactOrder[OrderAmount] ...Answered | 2 Replies | 4188 Views | Created by CF_AARDVARK - Thursday, January 21, 2016 9:36 PM | Last reply by greggyb - Friday, January 22, 2016 2:15 PM -
4 Votes
Calculating YTD from store procedure
It is the period starting January 1 of the current year until the last day of the pay cycle.Answered | 16 Replies | 1996 Views | Created by Evil Poster - Friday, February 21, 2014 11:31 AM | Last reply by Satheesh Variath - Saturday, February 22, 2014 5:35 PM -
0 Votes
YTD function for only the current year with lag months
Hi all, I want to create a YTD member in the cube based on the current month. i.e, if my current month is 'Sept 2012', this calculated member ...Answered | 1 Replies | 3275 Views | Created by Anish Tuladhar - Tuesday, March 6, 2012 3:02 PM | Last reply by AshimM - Thursday, March 8, 2012 9:33 PM - Items 1 to 20 of 1944908 Next ›
No announcements
