Look up value within a table

[juliaellershaw]

I’m trying to create a column that looks up the value in another row within a table. This is what my data looks like:

Question Number	Username	Answered	Timepoint
1	ID1	2	A
1	ID1	4	B
1	ID1	6	C
2	ID2	3	A
2	ID2	4	B
2	ID2	7	C

What I need is for a new column called Answered_A that pulls in the Answered value at timepoint A for each Unsername. It should look like this:

Question Number	Username	Answered	Timepoint	Timepoint_A
1	ID1	2	A	2
1	ID1	4	B	2
1	ID1	6	C	2
2	ID2	3	A	3
2	ID2	4	B	3
2	ID2	7	C	3

I’ve tried merging the table with itself, but I end up with all the values from Answered in the new column. I've also tried Lookupvalue but I can't get it to work.

Is there a DAX code that will do this?

[juliaellershaw]

That worked, thanks! 

[mahoneypat · Accepted solution]

Please try this DAX calculated column expression

Timepoint A =
CALCULATE (
    MIN ( Table[Answered] ),
    ALLEXCEPT ( Table, Table[Question Number], Table[User Name] ),
    Table[Timepoint] = "A"
)

Pat