Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Select Column via Variable DAX

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

DAX
Dynamic
power bi
  • sturlaws's avatar
    sturlaws
    6 years ago

    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.

1 Reply

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    6 years ago

    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.