Forum Discussion

eacy's avatar
eacy
Icon for Helper II rankHelper II
10 years ago

Using a text string from one column as a column reference in a calculated column

Hi,   I have one table with a column named TBLSYSTEMCODE[TCODE] containing a text string "DCREATED" and an column named TBLSYSTEMCODE[ID] containing the id "1"   Then I have a second table named ...
Need Help
v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi eacy,

 

Could you please share us some data sample, or a screenshot of your data model?

If I understand your issue clearly, you would like to use a column value to filter columns in another table, and I don’t think this is available currently.

What I could think out here is, to alter the table 2 “TBLPO”, transform this table and make it owns a column with the same value in “TBLSYSTEMCODE[TCODE]”, then use this two to filter the date.

Regards

eacy's avatar
eacy
Icon for Helper II rankHelper II
10 years ago

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.

 

 

  • v-micsh-msft's avatar
    v-micsh-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Hi eacy,

    I did a deeper research on this topic, still can't find any further helpful infromation on this topic.

    Please take consider to submit an idea on this.

    Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.