8 Replies Latest reply: Feb 3, 2017 6:06 PM by Mike Grattan RSS

    Variable in load editor with Set analysis expression

    Jurien Groot

      Hi,

       

      I am trying to load variables in the load editor. The variables include set analysis expressions.

       

      Example:

      Let vKPI_Budget = SUM({$<MonthNum ={'>=$(=vFMonth)<=$(=vTMonth)'}, Year={"$(=vYear)"}>}[Budget] );

       

      How can I load this in the Data Load editor? It gives issues with the {, '' and "".

       

      I prefer not doing it via an external excel with all variables, I know that works.