It looks to me that it is possible to place a list in a column by using {"element1","element2","element3"}. But what I have not seen is whether it is possible to access the elements of that list. (I want to stress that I'm talking about DAX, here, NOT Power Query). So I have tried various methods like [ListColName][1], [ListColName]{1}.
Why would I want to do something like that? I am doing what I think is a fairly expensive operation on a large table. I create a temporary table as a variable, and there are 3 columnvalues from that temporary table I am interested in. So my thought was that instead of doing this expensive operation 3 times and create 3 new columns, why not get hold of those 3 values the first time, put them in a list, and then just access that list, an operation that should be faster. I can't find any way of doing this.
