Create Measure in Data Load Editor, based on NEW measures

[Ray123]

Hi Community, 

I would like to create a new measure column, that is based on new measures columns as well. 

Example_Data:

LOAD

Column_A as Column_1,   // This works!

Column_B as Column_2, // This works!

Column_A  + Column_B  as New_Column_1,  // This works! 

New_Column_1 + Column_B  as example // Error: not possible to use 'New_Column_1' that is just created...

So, how can I create the 'New_Column_1' in the Data Load Editor? 

Many thanks in advance

[Taoufiq_Zarra · Accepted solution]

@Ray123  because the field is not yet loaded.

you can do for example :

Data:
LOAD Column_A as Column_1,Column_B as Column_2,Column_A  + Column_B  as New_Column_1, (Column_A  + Column_B + Column_B) as example  inline [
Column_A,Column_B
1,1
2,2
3,3
];

output:

or :

Data:

LOAD *, New_Column_1 + Column_2 as example;
LOAD Column_A as Column_1,Column_B as Column_2,Column_A  + Column_B  as New_Column_1  inline [
Column_A,Column_B
1,1
2,2
3,3
];

output: