Log In
Register
Home
May 2, 2014
Offline
I've added a new calculated column in a PowerPivot file - this is the formula..."=IF(and([Revenue Date]>=[S&M Contract Start date],[Revenue Date]<=[S&M Renewal Date - Finish]),"Yes","No")"
I've checked the brackets etc but it's evaluating to an error and the issue seems to be with the "yes", "no" part - what am I missing? Thank you
July 16, 2010
Offline
Hi Anne,
I can't see anything wrong with the formula, but maybe your data types for the date columns aren't set to date?
Hard to tell without seeing the file. Are you able to share a sample file that replicates the issue?
Mynda
May 2, 2014
Offline
You were right (as usual!). I had set the data types to date and refreshed but because some of the date entries were blank, it made the whole lot "Any". Filtered, refreshed, re-entered it and now it works. Of course I had forgotten to rename one of the columns but at least it's working now! Slowly, slowly, catchee Power Query Monkee...thanks a mil.
1 Guest(s)
