topic Referencing a column based on values in another column in DAX Commands and Tips

Referencing a column based on values in another column

David_ — Mon, 20 Jun 2022 12:12:20 GMT

Hi, I'm trying to tell which column I want to look in table b based on values in a column in table a. The column in table A have 1, 2, 3, 4 in them and table B have columns named 1, 2, 3, 4

In excel id use something like index/match but i can't wrap my head around what to do in DAX.

Below you can see what I'm kinda trying to do.

Column =

var _var1 = 'Table_A'[Column_1]

var _var2 = "'Table_B'[" & _var1 & "]"

return

RELATED(_var2)

Hope someone has some good input. Thanks in advance!

Re: Referencing a column based on values in another column

tamerj1 — Mon, 20 Jun 2022 12:34:41 GMT

David_

It dies not work this way with DAX. you need first to unpivot your table using power quert then you column names will become values in the Attributes column. Then filtering will be simple

Re: Referencing a column based on values in another column

David_ — Mon, 20 Jun 2022 12:56:51 GMT

Thank you.
I'm not really sure how this works?

Could you explain a bit?

Re: Referencing a column based on values in another column

David_ — Mon, 20 Jun 2022 13:35:34 GMT

Found how to do it, thank you for the help.