No announcements

### Calculating a measure between two dates

Hi, sorry but I'm new with PowerPivot but I don't think it is so hard to calculate a measure by filtering between two dates. It should be a ...
| 5 Replies | 6727 Views | Created by pscorca - Monday, May 23, 2011 3:26 PM | Last reply by pscorca - Tuesday, May 24, 2011 12:58 PM

### Calculating a measure between two filtered dates

Hi, I'm interesting to know how to calculate a measure between two dates to filter. Fe, I've a time table and a ...
| 7 Replies | 7364 Views | Created by pscorca - Friday, April 27, 2012 12:09 PM | Last reply by ruve1k - Monday, May 21, 2012 3:56 PM

### Calculated measure between two dates

of Amount where the selected date is between StartDate and EndDate. Like this   SELECT SUM(Amount) WHERE <date> ...
| 3 Replies | 4660 Views | Created by Andreas_Schneider - Sunday, September 5, 2010 4:59 PM | Last reply by Josh Ashwood - Monday, September 13, 2010 11:16 PM

### Calculating number of days between two dates

) but on a month-to-month basis: November: 20 days December: 5 days January: 31 days etc... So ...
| 2 Replies | 6402 Views | Created by ty-son - Monday, May 23, 2011 2:53 AM | Last reply by ty-son - Monday, May 23, 2011 10:22 PM

### calculating the difference between two dates

Hi, Check this link from Ramani's pages ** How to calculate the difference between two dates in Years, Months, Days ?
| 7 Replies | 11884 Views | Created by zahj - Wednesday, March 21, 2007 3:14 AM | Last reply by Tom Borgmann - Wednesday, April 4, 2012 1:35 PM

### Calculating difference between two dates (in workdays)

Can I calculate difference in workdays between two dates in an easy way? Is there a built in function in SQL Server that’ll work?
| 5 Replies | 2360 Views | Created by Marius Tarnat - Thursday, May 30, 2013 9:28 AM | Last reply by scott_morris-ga - Thursday, May 30, 2013 2:15 PM

### Trouble calculating date/time between two dates.

I would use DateDiff with an argument of d (days) to get the decimal number of days between your dates. you should just then be able to format this as a date so d hh:MM ...
| 13 Replies | 10832 Views | Created by DblR - Thursday, October 28, 2010 10:12 PM | Last reply by Mohamed Irshad - Thursday, December 2, 2010 4:02 AM

### calculating the difference between two dates

ie short dates to figure an average of how many days between occurances of a particular number. I have tried several different formats of dates..... ie ...
| 6 Replies | 3431 Views | Created by olsofty - Tuesday, April 21, 2009 10:47 PM | Last reply by olsofty - Wednesday, April 22, 2009 12:19 PM

### Calculating Business hours between two dates

); Thank You, Sammani http://sammanipalansuriya.blogspot.com/
| 3 Replies | 3872 Views | Created by Roger Warner - Tuesday, March 25, 2014 6:07 AM | Last reply by Nitin gupts - Tuesday, March 25, 2014 9:56 AM

### MDX to calculate measure between two dates

date and PostSalesEndDate refers to the addition of duration period to the End Date .  I have a cube which returns me the sales which happened ...
| 1 Replies | 1953 Views | Created by Savio Fernando - Thursday, January 24, 2013 1:51 PM | Last reply by Martin Mason - Thursday, January 24, 2013 1:54 PM

### Difference between two dates

table1 regid regdate table2 regid logindate how to take the difference between these two ...
| 1 Replies | 2986 Views | Created by SarahLee - Thursday, February 8, 2007 1:21 PM | Last reply by kbradl1 - Thursday, February 8, 2007 2:27 PM

### Measure Between Dates

sales between the two dates along these lines.  You will need to be able to convert StartDate and EndDate to the keys of date. ...
| 6 Replies | 1787 Views | Created by ArunaPavan - Wednesday, January 16, 2013 9:14 AM | Last reply by ArunaPavan - Friday, January 18, 2013 10:59 AM

### Calculating differences between dates

I am trying to calculate the number of days a system breakage has been open.  If the issue is ongoing I need the count to continue until closed. Date Notified: Opening ...
| 1 Replies | 4970 Views | Created by Zack Mays - Wednesday, April 7, 2010 3:46 PM | Last reply by Arpit Goyal - Wednesday, April 7, 2010 7:19 PM

### Days between two dates

I all, I want to find the amount of days between two dates. I have two columns In_date and Exp_date. I want to find out the ...
| 1 Replies | 5369 Views | Created by Milli_22 - Wednesday, August 11, 2010 12:37 PM | Last reply by PavanKokkula - Wednesday, August 11, 2010 12:42 PM

### Using a KPI to measure the progress between two dates

Hi Dan Good stuff. I've got to the stage now where I can get a percentage output between the start and due dates (that if course, if a start date ...
| 4 Replies | 9400 Views | Created by Duncan McDonald - Friday, February 5, 2010 2:18 PM | Last reply by Duncan McDonald - Monday, February 8, 2010 12:00 PM

### Calculating the number of months and days between two dates

I need the following. I want to calculate the number of days in each months along with the month name from a selected range of two ...
| 3 Replies | 2728 Views | Created by Amey Kelkar - Tuesday, September 4, 2012 5:06 AM | Last reply by Amey Kelkar - Tuesday, September 4, 2012 8:01 AM

### SSRS IF statement when calculating workdays between two dates

solution to calculate workdays between two dates by using custom code. I have tested this solution in my local environment, it works fine. Please refer to
| 3 Replies | 2870 Views | Created by Lylecwk1 - Tuesday, August 23, 2016 8:58 AM | Last reply by Lylecwk1 - Wednesday, August 31, 2016 6:53 AM

### Calculating % change between 2 dates

then start your task by building every single value as a separate measure in order to be able to track & check what is happening in a ...
| 6 Replies | 1191 Views | Created by עמיתת - Thursday, July 16, 2015 10:14 AM | Last reply by עמיתת - Tuesday, August 4, 2015 7:06 PM