Hi,
I need a help to make an expression for SSAS Calculated Measure definition.I have 2 definitions for the same calculated measure, but they need to be applied on DATE filter. That is before a certain date the expression needs to be calculated using a different
definition, and after the date the Calculated Measure will be calculated using the different expression.
Any Suggestions on how to achieve that?
for example if i have the two expressions
-------
([ActionTag].[Actions Hierarchy].[Campaign].&[Atlas].&[etools Confirmation],[Measures].[Conversions])
----------
SUM
( {
[ActionTag].[Action Tag].&[526284]
,[ActionTag].[Action Tag].&[526283]
}
,[Measures].[Conversions]
)
-----
PS- If i am addressing it at the wrong location, please guide me . Thanks.
Suvrat
