No announcements

### How to calculate no of days between FirstDate and LastDate in PowerPivot using DAX function

/2014) and MAX date (which is 18/04/2014) based on this condition OutCome <>"VC". I have tried to use this DAX ...
| 2 Replies | 1236 Views | Created by SS_2011 - Tuesday, November 11, 2014 4:33 AM | Last reply by SS_2011 - Wednesday, November 12, 2014 5:34 AM

### DAX Question regarding context of LastDate when used in Calculate

This is the expected behaviour. The 3 filter conditions to your CALCULATE() are evaluated independently. If you want the LastDate calculated in the context ...
| 1 Replies | 926 Views | Created by golfgod - Monday, January 28, 2019 8:05 PM | Last reply by Darren Gosbell - Wednesday, January 30, 2019 2:38 AM

### dax: FIRSTDATE function in IF statement

I'm facing some error which is related to filter context. This is what I tried IF([date]=FIRSTDATE[date], 1, 2) Any other ...
| 1 Replies | 3070 Views | Created by powerpivotq - Monday, June 10, 2013 3:23 PM | Last reply by Matthaeus Woroch - Wednesday, June 12, 2013 7:35 AM

### PowerPivot - How to use DAX calculate function (dynamic segmenation)

Hello, I am trying to build up a formula by using DAX functions to be able to cluster values (\$0-\$1000, \$1000-50000, etc.) ...
| 1 Replies | 547 Views | Created by Petr Sk - Thursday, September 8, 2016 6:50 AM | Last reply by Angelia Zhang - Friday, September 9, 2016 11:14 AM

### calculate no of days

Hi, I want to get the no of saturdays that are coming between given span of days, ex:- if i give dates as 04/05/08 ...
| 2 Replies | 5348 Views | Created by Bhaskar Ravindranath - Friday, April 25, 2008 3:51 AM | Last reply by eralper - Friday, April 25, 2008 10:36 AM

### How to calculate % of increase between days

Hi, I am not sure how to write a query to calculate % of increase of different values between various days. To explain ...
| 9 Replies | 7957 Views | Created by kapiszon2929 - Wednesday, March 17, 2010 7:35 PM | Last reply by kapiszon2929 - Thursday, March 18, 2010 8:57 AM

### how to calculate total no of days in List column

Hi, I've start date and end date. Can you please help me how to calculate total number of days. Column Name ...
| 1 Replies | 1017 Views | Created by Pintu_SP - Wednesday, February 4, 2015 9:05 AM | Last reply by Pintu_SP - Wednesday, February 4, 2015 10:46 AM

### SQl Query to Calculate No of Days from LastDate and PreviousDate

INSERT statement had error and incorrect data. I changed itRent column had INT data type and I changed it to Money. DECLARE
| 1 Replies | 519 Views | Created by jaggy99 - Wednesday, March 11, 2015 7:21 AM | Last reply by Vaibhav.Chaudhari - Wednesday, March 11, 2015 8:25 AM

### Calculate working days between dates using PSI

in the app.  To calculate it, I need to determine how many working days (or more specifically duration units) there are ...
| 1 Replies | 10579 Views | Created by Baloodevil - Monday, November 15, 2010 9:59 PM | Last reply by Jim Corbin - Tuesday, November 16, 2010 5:14 AM

### Dax question. Summarizing lastvalue - lastdate correctly ?

Hi dizzy43, In DAX, we can apply filters in CALCULATE() function to achieve your goal. The expression can be ...
| 1 Replies | 429 Views | Created by dizzy43 - Wednesday, March 9, 2016 1:07 PM | Last reply by Simon_Hou - Thursday, March 10, 2016 1:06 PM

### Calculate working days function

. I am now however trying to calculate the total number of days (working days and weekend) between 2 ...
| 12 Replies | 4361 Views | Created by PaulNic - Wednesday, July 22, 2009 11:39 PM | Last reply by PaulNic - Thursday, July 23, 2009 11:24 AM

### Custom Function to calculate days

result.  I think I do not know how to write the code for each valid and related to the fields in the table. I was able to ...
| 13 Replies | 7810 Views | Created by sunnyplace - Tuesday, December 14, 2010 10:44 PM | Last reply by sunnyplace - Thursday, January 13, 2011 1:11 PM

### Calculate passing days (between dates)

Hi, How can i calculate the passing days between two dates, i have EndDate (2009-12-2) and BeginDate (2009-11-29), and i ...
| 4 Replies | 3606 Views | Created by Joao Prata - Thursday, December 10, 2009 11:49 AM | Last reply by Joao Prata - Thursday, December 10, 2009 11:57 AM

### calculate days between dates

I would like to have a field in a report that counts the days between two dates.  I've got a DateRcvd field and a DateComplete field.  Both ...
| 8 Replies | 4402 Views | Created by taking - Thursday, May 12, 2011 5:25 PM | Last reply by taking - Thursday, May 12, 2011 8:31 PM

### PowerPivot DAX: Using project start and end date, Calculate Number of days per Month of an individual person.

calculated measure using DAX) should be the numbers of days in each month.  Booking
| 2 Replies | 6276 Views | Created by MALI_DBA - Thursday, March 8, 2012 1:03 AM | Last reply by MALI_DBA - Thursday, March 8, 2012 10:45 PM

### how to calculate no of days in two different dates in CR at run time?

how to calculate no of days in two different dates in CR at run ...
| 1 Replies | 3566 Views | Created by Rashesh - Saturday, July 31, 2010 6:24 AM | Last reply by BernieHunt - Monday, August 2, 2010 10:43 PM

### PowerPivot - Calculate Function doesn't work?

Hey everyone, i really hope someone can help me out with this. I am trying to repeat the sample of Marco Russo and Alberto Ferrari in their ...
| 8 Replies | 10197 Views | Created by Erschone - Friday, July 1, 2011 5:46 AM | Last reply by Marco Russo - Tuesday, July 12, 2011 8:58 PM

### DAX FIRSTDATE in a filter context - Contoso example

as second argument to CALCULATE, all the columns of DimDate are implicitly part of the filter, too - but only days with at least one sale will be part ...
| 5 Replies | 6537 Views | Created by M. Shparber - Friday, March 8, 2013 12:10 PM | Last reply by M. Shparber - Friday, March 8, 2013 11:16 PM