Forum Discussion
Solved
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...
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!