Dax function to show value from a different line and column

[Anonymous]

Hello everyone,

In a table,  I would like to create a new column where it will show the value of an existing column [AnswerText] if my column [AnswerCode] is equal to "A1629032" and I want this value to be written in the same line as the [QuestionCode]="Q1228101"

Basically, value in C3 should be written in D5 and D7 : 

Thanks in advance,

[JustJan · Accepted solution]

Hi @Anonymous ,

Something like this should calculate your column:

NewColumn = if ('Table'[QuestionCode]="Q1228101", LOOKUPVALUE('Table'[AnswerText],'Table'[AnswerCode],"A1629032"))

Jan 

[Anonymous]

Thank you for the answer!