27 April 2012 7:05
I am new to PowerPivot and am still learning it's limitations.
I have a formula I am using to created an additional column inside of the
PowerPivot Table that shows an inconsistent results. <o:p></o:p>
Here is my formula.<o:p></o:p>
And below is the result set. It is calculating a blank ReportedClosedDate
and that is an error.<o:p></o:p>
If I attempt to use the "IsBlank" function like this:
Power Pivot throws a syntax validation error.
Any guidance you can offer will be greatly appreciated.
- Merry Pettijohn
27 April 2012 12:20
Are your blank cells empty or zero length strings? I've had this problem myself and it turned out I had a zero length string.
27 April 2012 12:56
i just rebuilt your sample and this calculation worked just fine for me:
- www.pmOne.com -
02 Mei 2012 9:51
hi can you please check the below forum for your reference.