Forum Discussion
Look up value within a table
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?
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
2 Replies
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
That worked, thanks!
