Forum Discussion
Using a text string from one column as a column reference in a calculated column
Hi Michael,
Thanks for your feedback.
If you think about it, it is quite complicated to document and I belive you got it right.
The main problem I face is to pick up a string from a field and reuse it as a column reference like:
I have:
TABLE[reference string] = "Column A"
I want to use it like:
IF(TABLE[Column A] = TRUE;bla bla bla)
I would like avoid to add any infomation to the TBLPO table as you suggest because in the future I would like to easily exchange that tabel with a table from another backend system.
I know this is an old post but I have the exact same issue and was curious if this has been resolved in another post. I am being passed 1 table with a single column list of job roles ("Salesperson", "Warehouse", "CounterSales") and then I have a complex table with the persons name and those three roles as column names(Columns = AssociateName, Salesperson,Warehouse,CounterSales.) Please understand this is actually around 100 roles but I simplified. Is there a way to SUM or FILTER by passing the variable from the list TABLE[reference string] = "Salesperson" and using it as a column reference similar to example above SUM(TABLE[SalesPerson])? Thank you in advance.