Forum Discussion
Evaluate a string as a column name
Hi, I'm new to Power BI and I'm having some troubles trying to evaluate a string as a column name. I have a table like BIG TABLE Field1, Field2, ..., Field30 0.3, 0.4, ..., 0.2 0.5, 0.2, .....
Hi,
I'm new to Power BI and I'm having some troubles trying to evaluate a string as a column name.
I have a big table like
BIG TABLE
Field1, Field2, ..., Field30
0.3, 0.4, ..., 0.2
0.5, 0.2, ..., 0.88
...
and a slider like
FIELDS
FIELD_X
Field1,
Field2,
...,
Field30
I get what I select on the slider as Selected_X = SELECTEDVALUE(FIELDS[FIELD_X]). So, if I select "Field13" on FIELD_X I get Selected_X ="Field13".
Now I want a columnX to become dynamically equal to 'BIG TABLE'[Field13].
I tried column_X="'BIG TABLE'[" & Selected_X & "]" but it didn't work.
How can I get this?
Thanks,
Carla
Did you ever obtain your solution? I am having same issue. It would be great help if you could post how u approach to get a solution.
Thanks,
K