Forum Discussion
smpa01
Community Champion
Community ChampionConstructing table in Dax from Variables
I am trying to figure out how can I end with a table from at least two variables
My code is following
Table =
VAR first = "a"
VAR second = "b"
VAR x= CROSSJOIN(DATATABLE("column1",STRING,{...
smpa01 Not sure if this is what you are looking for? You can do crossjoin these two variables and rename the column name, or use selectcolumns and then cross join
Table = VAR a = {"a","b","c"} VAR b = {"e", "f","g"} RETURN CROSSJOIN ( SELECTCOLUMNS ( a, "First", [Value] ), SELECTCOLUMNS ( b, "Second", [Value] ) )or you want row 1 of each table to join and then row 2 to row 2 and so on...
what is your end goal?
parry2k
Super User
Super Usersmpa01 Not sure if this is what you are looking for? You can do crossjoin these two variables and rename the column name, or use selectcolumns and then cross join
Table =
VAR a = {"a","b","c"}
VAR b = {"e", "f","g"}
RETURN
CROSSJOIN ( SELECTCOLUMNS ( a, "First", [Value] ), SELECTCOLUMNS ( b, "Second", [Value] ) )
or you want row 1 of each table to join and then row 2 to row 2 and so on...
what is your end goal?
