5 Replies Latest reply: Oct 6, 2015 11:43 PM by guohao yee RSS

    How to include an formula in an expression?

    guohao yee

      Hi All,

       

      I am trying to obtain the value for the first month of the year. (E.g. 1/1/2015.) in order to compute YTD % Change.

      Sum({$<Date={'=$(YearStart(Max(Date)))'}>}[Sales])

      Ideally, it should be evaluated as

      Sum({$<Date={'1/1/2015'}>}[Sales]).

       

      Please kindly advise!

      Thanks in advance!