Here is the issue; Some of our metrics (measures) reference the 'close date' field (when a deal was closed) and other measures need to reference the credit date (when the deal earned revenue). I need to build out a text table that can have both measures with a date filter that will update the close date reference for some measures and the credit date for other measures.
Is there an easy way to do this or a creative workaround?
I'm not wrapping my head around this question.
When you say "update the close date reference..." what do you mean by that?