Reference Column Number with Measures

[Nie]

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 need to write measures for with DAX.

Is it possible to reference the columns by their number instead of their name? For example, first column might be Table[0], second column might be Table[1] ... etc.

I am thinking if referencing by number is possible, I can store this in a variable and then reference the column dynamically when writing my measures.

Or if there is a better way, please let me know, I only have very basic DAX knowledge.

[Anonymous · Accepted solution]

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 😞

[Nie]

Thank you. Appreciate the information.