Say I have a table "Data" (created with the "Format as table" button, with headers). In another table (say "Table"), I have a column ("Target column") that has values in the column names of the "Data" table and a column "Median". In the "Median" column, I want to have the median value of the column that is given in the "Target column" column of table "Data".
I tried to do Median(Data[A2]) where A is the column index for the "Target column" column. This of course doesn't work. I suppose something like it could work with INDIRECT, but I'm not sure that's the most performant solution.
Say my table "Data" has columns "val1", "val2", "val3" and my table "Table" I have columns "Target column", "Median". For any column name of table "Data" in the "Target column", I want to have the median of that column in the table "Data" in the column "Median" of the table "Table".