topic Re: Dax function to show value from a different line and column in DAX Commands and Tips

Dax function to show value from a different line and column

Anonymous — Wed, 12 Feb 2020 16:11:16 GMT

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,

Re: Dax function to show value from a different line and column

Anonymous — Wed, 12 Feb 2020 18:33:53 GMT

Hi Anonymous ,

Something like this should calculate your column:

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

Jan

Re: Dax function to show value from a different line and column

Anonymous — Thu, 13 Feb 2020 10:11:51 GMT

Thank you for the answer!