Help duplicating a formula in PowerPivot

[kF1894]

The networkdays portion of this formual does not work in Powerpivot - What else can I use?

=IF([@Status]="One & Done",0,IF(OR([@Status]="Opened Yesterday",[@Status]="Opened Prior"),NETWORKDAYS(Q2,F2),IF([@Status]= "Closed Yesterday",1000,"")))

 

[powerpivotpro]

Is this a calculated column or a measure?

 

[kF1894]

A calculated column

 

[powerpivotpro]

Hey I never realized that PowerPivot lacked a NETWORKDAYS() function! I worked up a fix for this, send me an email and I will send you the workbook. Email address is hidden in my signature.

 

[powerpivotpro]

OK it's posted here: NETWORKDAYS() Equivalent in PowerPivot? « PowerPivotPro

 

[kF1894]

Appreciate the help - worked great with & without the Holidays - LOL