### Reporting different periods across years with previous period

measures. We want to analyze measures (sliced by different dimensions) and filter the time across years. To do this, we select the time dimension as filter and ...
| 6 Replies | 753 Views | Created by hpo_mh1 - Thursday, November 7, 2019 1:23 PM | Last reply by hpo_mh1 - Wednesday, November 13, 2019 2:17 PM

### Same period previous year

is created by the time intelligence for YTD and others I don't know wat's wrong. I tried different things.  Is there any other way to calculate same period ...
| 1 Replies | 4136 Views | Created by sql sathi - Monday, April 6, 2009 3:18 AM | Last reply by DSU007 - Monday, April 6, 2009 5:34 AM

### Period to date for previous period

You can use ParallelPeriod() to get the equivalent member in the previous period, like: SUM (  ...
| 1 Replies | 2538 Views | Created by jschroeder - Thursday, December 1, 2011 11:48 PM | Last reply by Deepak Puri - Friday, December 2, 2011 12:08 AM

### Sum the same period of this and previous year

Hi, I got this hierarchy of Time. I need to sum sales from selected period in this year, and sum same period in previous years
| 2 Replies | 3014 Views | Created by Justinszs - Monday, March 5, 2012 10:31 PM | Last reply by RichardLees - Tuesday, March 6, 2012 5:32 AM

### Compare the same period of different years

different years (2005 and on). My customer wants a report that shows the sales of the current year up to the month he wants to specify (e.g. january - march 2008) ...
| 1 Replies | 4839 Views | Created by Beneventi - Wednesday, May 21, 2008 10:25 AM | Last reply by DoolinDalton - Wednesday, May 21, 2008 2:28 PM

### Compare Previous Year and Month Period and Current Year and Month Period

MEMBER [Measures].[Previous Year Sale] AS      (       [Date].[Calendar].
| 1 Replies | 4786 Views | Created by wOOkies - Friday, September 2, 2011 8:09 AM | Last reply by Aniruddha Thengadi - Friday, September 2, 2011 8:59 AM

### Previous Existing Period?

for it to work on different hierarchy levels (that is month returning previous month, year returning previous year, etc.) thanks
| 2 Replies | 3652 Views | Created by algkep - Wednesday, November 18, 2009 7:27 PM | Last reply by algkep - Wednesday, November 18, 2009 8:43 PM

### Generic Previous Period Calc

or hierarchy from the above mentioned date dimensions, the calculation should return the [Previous Period Sales Amt] on a measure called [Sales Amount]. [Previous ...
| 3 Replies | 2806 Views | Created by GBaksh - Wednesday, May 16, 2012 3:51 PM | Last reply by Martin Mason - Thursday, May 17, 2012 10:51 PM

### Parallel period for previous year using two months

Dears, I have an issue, Parallel period is working just fine and returning values of last year same month values like this ...
| 0 Replies | 697 Views | Created by JorjeR - Friday, June 27, 2014 6:48 AM

### MDX Calculation - Previous Period

I am new to MDX and unable to get a very simple calculations to work.   All I am trying to do is perform calculations between values in different time periods.  I ...
| 2 Replies | 9421 Views | Created by Patrick Grant - Monday, August 9, 2010 12:59 PM | Last reply by Patrick Grant - Monday, August 9, 2010 3:14 PM

### Period To Period, Prev 2 year - same periods Calculation

Hi Raunak, Sorry, I was a bit away. Do you have a sample to pull previous 2nd year on a selected period range? And also to display ...
| 5 Replies | 3727 Views | Created by VankayS - Tuesday, May 15, 2012 10:10 PM | Last reply by VankayS - Tuesday, May 22, 2012 7:07 PM

### Calculating YTD and Previous Period YTD effectively in the same Pivot

I am working on a PowerPivot file where I have to display specific measures by Current Fiscal YTD and Previous YTD in the same table across 10 different measures.  I am ...
| 3 Replies | 9575 Views | Created by N. Edmonds - Wednesday, February 15, 2012 9:04 PM | Last reply by Javier Guillen - Thursday, March 1, 2012 4:43 AM

### Matrix: percentage growth same period previous year

I solved it by making a new TSQL query. For others with the same 'problem' this is my solution: I created a select statement for the ...
| 6 Replies | 1302 Views | Created by WillemCls - Tuesday, August 4, 2015 8:12 AM | Last reply by WillemCls - Tuesday, August 4, 2015 1:39 PM

### Parallel period syntax for last period of previous month

I am struggling with the Parallelperiod function in a calculation. What I want to achieve is to compare a certain measure to the same measure from previous year, but then not the ...
| 4 Replies | 3926 Views | Created by Erik Monchen - Tuesday, October 13, 2009 10:56 AM | Last reply by Deepak Puri - Wednesday, October 14, 2009 5:38 AM

### Previous Period Calculation

) aggregates all the previous week's values, rather than the single value required (80,003). Because we have a lot of different measures which would ...
| 20 Replies | 2757 Views | Created by Kenmack - Friday, September 13, 2013 4:49 PM | Last reply by Kenmack - Wednesday, September 18, 2013 10:48 AM

### Year total calculation impacted by period selection

. I have a dimension time which has different levels (year, period - which is a 4 weeks period - and week). The ...
| 0 Replies | 479 Views | Created by Barry van Dijk - Friday, November 1, 2013 10:05 AM

### Compute billing in previous period

to determine the "Growth in Professional fee billed over the previous period" - please note that previous period need not be previous ...
| 9 Replies | 952 Views | Created by Ashish Mathur - Sunday, June 14, 2015 12:11 AM | Last reply by Ashish Mathur - Saturday, June 20, 2015 6:11 AM

### Ranking Periods within Year

Hi, My intention is to rank my periods in a year. So each year the first period gets 1, the second 2, .... The query ...
| 6 Replies | 3552 Views | Created by Cees van Diermen - Thursday, June 10, 2010 9:51 AM | Last reply by Uri Dimant - Thursday, June 10, 2010 10:19 AM