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 r...
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.

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident 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.