topic Re: GENERATESERIES[Value] reference in DAX Commands and Tips

GENERATESERIES[Value] reference

tctrout — Thu, 16 Jul 2020 13:56:25 GMT

Hello,

I have a base question where I would like to know why I cant 'qualify' the table name for the column [Value] that is created i the GENERATESERIES() measure. See the below example.

I find it confusing to only refer to [Value] and prefer to qualify it with the table name first.

//This DAX Works

TableTest =

var SeriesTest = GENERATESERIES(1,10,1)

var AddColumnTest =

ADDCOLUMNS(SeriesTest

,"ColumnAdd"

,[Value]) //However, why cant this be referred to as SeriesTest[Value]

return

AddColumnTest

Re: GENERATESERIES[Value] reference

Anonymous — Thu, 16 Jul 2020 14:00:41 GMT

Because SeriesTest is a name for a variable, not for a table. The table created by the function is anonymous.

Best
D

Re: GENERATESERIES[Value] reference

tctrout — Thu, 16 Jul 2020 14:06:50 GMT

Ah, thank you, I forgot that when used in a variable the table doenst actually 'materialize'. I confirmed, once 'materialized', I can qualify it in another calculated table:

TableTest2 =

ADDCOLUMNS(TableTest,"ColumnAdd2",TableTest[Value])

I do have a follow up, and not sure of the scenario, but what if the DAX requires multiple GENERATESERIES()? How will it know which [Value]? Or will it not allow me, and the work around would be to nest another return with a new var GENERATESERIES()?

Re: GENERATESERIES[Value] reference

Anonymous — Fri, 17 Jul 2020 10:20:00 GMT

// Easy enough to check... // This gives you an error: EVALUATE CROSSJOIN( GENERATESERIES(1, 10, 2), GENERATESERIES(2, 10, 2) ) // You can do this instead: EVALUATE CROSSJOIN( GENERATESERIES(1, 10, 2), SELECTCOLUMNS( GENERATESERIES(2, 10, 2), "Value2", [Value] ) )

Best

Re: GENERATESERIES[Value] reference

tctrout — Fri, 17 Jul 2020 11:03:49 GMT

Thank you, makes sense, I'll be keeping this in my back pocket.