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

    Variable in load editor with Set analysis expression

    Jurien Groot



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



      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.