column number
1 Topic
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 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.Solved2.1KViews0likes2Comments