Have your tried some like:
IF [Date Field] < [Close Date]
If this doesn't work trying mocking up an example and packaged workbook
Thanks! So for the [Date Field] table, I would just mock up some dummy dates to compare against?
I'm not sure I understood the original question based on your response. From your original post it sounds like you have a field that has dates and a field for close date. This is where I made the assumption that there was a Date Field. Could you please explain a little more if this is not the case.
I've attached my source data and a workbook where I tried doing the calculated field you suggested earlier. I created a table of dates called Current Month to have dates to compare the Closure Date by, and then calculated the month off each date to relate those two tables. For this example I'm assuming the residual DPU to be 0.3 as a constant. I also need the residual DPU to stay constant for 3 months after the Closure Date and then go to 0 (I forgot about that in my original post, sorry). Here's the calculation I tried for DPU by Month:
if ATTR([Sheet1 (Current Months)].[Current Month])<attr([Clse Dt])
elseif month(attr([Clse Dt]))<month(ATTR([Sheet1 (Current Months)].[Current Month]))+3
elseif month(attr([Clse Dt]))>month(ATTR([Sheet1 (Current Months)].[Current Month]))+3
Hopefully that helps clear up what I'm getting at a little better! Thanks for the help!
I figured it out! I just added a Date column to the NPI issues data source to use instead of the separate table. This way I didn't have to use the aggregated data functions and link the two tables. Then it worked!
Well, I thought that had worked, but upon closer inspection it only worked for the first few values (since there are only a few records in the Dates column). Any further ideas would be really helpful!