Forum Discussion
Solved
Index column
Is it possible to create an index column in DAX out of thin air, like it is doable in SQL
drop table if exists #test
select * into #test
from
(values('a'),('1'),(null),('xxx'),('-100')) t (a)...
AlexisOlson I need a row identifier cause I am spliting a factTable[Field] to a new table, with schema VARCHAR (e.g. a|b|c / e|f|g|h) using PATHITEM, which is why I need a row identifier between factTbl and derivedFactTbl to create relationship (1:M).
Greg_Deckler has a great solution which works very well on a narrow table (n X 1) but not on a wide table (n X m). Nevertheless, thank you.
I managed to create a surrogateID by concatenating all the columns particpating in SUMMARIZECOLUMNS and then I created derivedTable with that SID.
Greg_Deckler thanks for this, will let you know how it goes for me