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
tctroutResponsive Resident
Responsive ResidentAh, 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.