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
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
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.
🙂 glad it's sorted now and you're one step closer to Power Pivot/Query mastery!
