No announcements

### Calculating Discount every year for same dates?

, Christmas as my DiscountName, 0.15 as my Discount%. I want a DAX formula which calculates Discount every year with the above ...
| 2 Replies | 6277 Views | Created by Arjun M Shetty - Sunday, September 27, 2015 7:05 AM | Last reply by Arjun M Shetty - Thursday, August 23, 2018 1:20 PM

### Calculating Dates

I have MOSS 2007 Here is my question how do I calculate dates to get how many days are between two dates excluding time. This works fine in one ...
| 1 Replies | 3745 Views | Created by SharepointJunky - Wednesday, November 2, 2011 7:49 PM | Last reply by Pengyu Zhao - Friday, November 4, 2011 2:28 AM

### Calculating dates

If this is 2015 Q3, one quarter ago is 2015 Q2, so 5 quarters ago would be 2104 Q2.  But that is just semantics: as long as you are getting what you want....   But - Check ...
| 3 Replies | 395 Views | Created by Casey_M - Friday, September 4, 2015 2:19 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Friday, September 4, 2015 4:38 PM

### Getting values for every year

C1=18.4.2012   What I want to have is the part value for each year. Between B1 and C1 are 838 days. This results in 0.5 ...
| 2 Replies | 3518 Views | Created by Nijazi_H - Friday, February 11, 2011 3:02 PM | Last reply by Joel Engineer - Saturday, February 12, 2011 12:34 PM

### Calculating dates

=DateAdd("m",-11,Date()) Hope that helps... PS. Unless
| 1 Replies | 329 Views | Created by Casey_M - Wednesday, July 29, 2015 6:26 PM | Last reply by .theDBguy - Wednesday, July 29, 2015 6:34 PM

### calculating Dates

then year(dates
| 3 Replies | 4870 Views | Created by Don Sallow - Thursday, November 1, 2007 8:28 PM | Last reply by Arnie Rowland - Thursday, November 1, 2007 10:44 PM

### calculating amounts per year

because 2014 has a duration of half a year and 2015 a full year - so the full duration of the agreement is one and a half years. This is just an example - I need a ...
| 14 Replies | 587 Views | Created by danisroyi2 - Wednesday, January 16, 2019 12:00 PM | Last reply by Stefan Hoffmann - Wednesday, January 16, 2019 4:07 PM

### Calculating Full Year Total

I wanted the much the same results as my original query but for the current year, for this I used the following.
| 3 Replies | 4504 Views | Created by CRollitt - Thursday, August 26, 2010 3:12 PM | Last reply by CRollitt - Friday, August 27, 2010 9:41 AM

### highlighting Q4 every year

Hi i need to highlight Q4 across the the planner every year with different color. is there a ...
| 2 Replies | 3827 Views | Created by WTashkandi - Wednesday, July 18, 2012 3:45 PM | Last reply by Ismet Kocaman - Wednesday, July 18, 2012 7:09 PM

### Calculating columns with dates

the date last month of this year and the date 2 months ago this year. Now i've already calculated those two dates with the following ...
| 6 Replies | 5606 Views | Created by AlphaVictor87 - Friday, July 9, 2010 4:11 PM | Last reply by Tom Li - MSFT - Thursday, July 15, 2010 2:04 AM

### Calculating and formatting dates

("en-GB") ' convert the strings to Dates Dim today As Date = DateTime.Parse(todaysDate, ci) Dim expiry As Date = DateTime.Parse(expiryDate, ci) ' format ...
| 6 Replies | 1226 Views | Created by Sid Williams - Sunday, September 23, 2012 9:31 AM | Last reply by Cor Ligthert - Monday, September 24, 2012 7:00 AM

### Calculating Quarterly Dates

insert data for the past 10 years.but i need it for quarterly. -- Set @EOM to end-of-last-quarter date ...
| 3 Replies | 3558 Views | Created by bal123 - Thursday, June 17, 2010 2:24 PM | Last reply by bal123 - Saturday, June 19, 2010 2:03 PM

### Calculating dates problem...

DateDifferent function it returns the project is late even if both dates are on the same day.  Is there anything I can do about this?   Many ...
| 5 Replies | 711 Views | Created by JamesP435 - Wednesday, June 14, 2017 1:56 PM | Last reply by JamesP435 - Thursday, June 15, 2017 1:57 AM

### Calculating Dates From Text

at this point I need to use Access or some other route to evaluate the text string (particularly in view of the fact I ultimately need to use the other dates for reporting)...
| 13 Replies | 4702 Views | Created by richardlpalmer - Monday, March 30, 2009 5:52 PM | Last reply by richardlpalmer - Thursday, April 9, 2009 12:35 AM

### Not calculating dates correctly

FormatDateTime returns a text string. Unless your computer uses yyyy/mm/dd as date format, the text representation of a date is not suitable for date comparisons. Simply ...
| 2 Replies | 635 Views | Created by Bucko10Rodgers - Friday, February 7, 2014 4:16 PM | Last reply by Bucko10Rodgers - Friday, February 7, 2014 6:13 PM

### Calculating Financial Year Figures

So I would like all the financial quarter counts for the year...
| 4 Replies | 3705 Views | Created by Sam233 - Monday, January 11, 2010 10:48 AM | Last reply by Justanewone - Monday, January 11, 2010 12:26 PM

### MDX, SSAS 2005 calculating SPLY (Same Period Last Year)

situation when you are on the first year in your time dimension and you compare it with the previous, obviously non-existing one. If you try to take the value there, you'll get null, but if ...
| 8 Replies | 11997 Views | Created by Adam_P - Thursday, August 6, 2009 7:44 AM | Last reply by Adam_P - Friday, August 7, 2009 4:14 PM

### Calculating a measure respects to dates in the same week

Hi, I'm trying to create a measure respect to dates falled into the same week of a date selected by a slicer. I've noticed that the time intelligence functions are ...
| 3 Replies | 2016 Views | Created by pscorca - Monday, January 28, 2013 6:32 PM | Last reply by Gerhard Brueckl - Tuesday, January 29, 2013 5:42 PM