Forum Discussion
tctrout
Responsive Resident
Responsive ResidentGENERATESERIES[Value] reference
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. ...
Because SeriesTest is a name for a variable, not for a table. The table created by the function is anonymous.
Best
D
Because SeriesTest is a name for a variable, not for a table. The table created by the function is anonymous.
Best
D
Best
D
tctroutAh, 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()?// 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
D
- tctrout
Thank you, makes sense, I'll be keeping this in my back pocket.