Forum Discussion

Nie's avatar
Nie
Helper I
5 years ago
Solved

Reference Column Number with Measures

I have a table with 10 columns. The first 5 have fixed column names. The last 5 have column names that I would like renamable by a layman according to needs. These last 5 columns are also ones that I...
  • Anonymous's avatar
    Anonymous
    5 years ago

     

    No, it's not possible to have dynamic columns and/or DAX. Column names must be known at the time of data load and can't be changed afterwards dynamically by the user. Also, in DAX there is no concept of column order and indexing into them with a number.

     

    And I'm afraid what you'd like to pull off is not possible in DAX at all 😞