Indexing a row to a column in another table

[Anonymous]

Hi,

I have one table with supplier names and respective index values. (Table 1 )

I have another table  with survey answers from different suppliers ; each column here stands for supplier answers. There are 20 columns as 20 suppliers and each row states one feedback answer from the survey. (Table  2)

I want to link each supplier name from table 1 to a specific column in table 2.

Thank you !

[v-shex-msft]

Hi @Anonymous,

I also think use unpivot column to convert these fields to attribute and value will be a better choice to handle this scenario. Dax expression was not suitable to calculate across multiple fields, it means you need to union function to manually extract each value field from the table and mapping with current records. (BTW, large and complex expression with multiple lopping will spend huge amount of memory resources, they may cause the memory out issue)

Regards,

Xiaoxin Sheng

[parry2k]

@Anonymous you are going to make it super complicated and there is no point solving it thru dax, if I were you I will work on preparing the data in the right way to make it work. there is no point in spending time and writing complex dax which can be achieved with proper data modeling. Rest it is your call.

[parry2k]

@Anonymous best is to unpivot your survey table so that supplier name and their reply are on the rows instead of columns and from there everything should be straightforward.

[Anonymous]

I cannot unpivot as each question has subcategories and I have indexed them accordingly. 

Is it possible to do this in DAX ? I am trying to create a hybrid matrix therefore need to index a supplier row to a specific column in the survey table