Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
That worked, thanks!
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |