Dynamic Select Column via Variable DAX

[Anonymous]

Hi All,

is it possible to use a variable to select dynamically a column? Example

TABLE A

--------------------

NewColumn = 
var name_column = "Column" & (5+1)
return
---> Here I want to return the values of "Column6" (5+1), based on variable "name_column" who has been calculated dynamically <----

Thanks

[sturlaws · Accepted solution]

Hi @Anonymous,

Only way I can think of is to create a switch statement:

new column =
SWITCH ( 
yourCalculationValue, 
1, column1, 
2, column2, 
.
.
.
.
.
6, column6,
blank )

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.