Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |