DAX - Confused over use of VAR

[BlueSky]

Hi,

Another newbie question, I'm confused over the use of variables.

In the first statement below, I'm able to define, myValue = [Value]  (created by GENERATESERIES () and use this in the second argument for GENERATE().

However in the second statement, I'm trying to do the same thing with ADDCOLUMNS() yet it produces an error ( 'Parameter is not the correct Type, cannot find [Value]'

Can someone help explain?

NewTable =
GENERATE(
GENERATESERIES ( 0, 10, 0.5 )
, VAR myValue = [Value]
return
row("Test",myValue)
)

NewTable =
ADDCOLUMNS(
GENERATESERIES ( 0, 10, 0.5 )
, VAR myValue = [Value]
return
"Test",myValue
)

[amitchandak]

Try like

NewTable = 
ADDCOLUMNS(
GENERATESERIES ( 0, 10, 0.5 )
, 
"Test", [Value]
)

[BlueSky]

Thanks for the reply but you've not answered the question, I'm trying to understand why the variable produces an error in the second senario, when it's usage is the same as the first (where there is no error).

[Husain · Accepted solution]

@BlueSky 

You must use the variable inside the expression where value is evaluated

so this should work

NewTable = 
ADDCOLUMNS(
GENERATESERIES ( 0, 10, 0.5 )
, 
"Test",VAR myValue = [Value]
return myValue
)