Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a table with multiple entries for each person depending on the step in the process. I'm looking to pull those dates from the other rows into one row. I've been trying RequestSentDate = LOOKUPVALUE(Sheet1[Activity Date],Sheet1[Activity],"REQUEST SENT") but am getting A table of multiple values was supplied where a single value was expected. error. I'm not sure what I'm missing, any ideas?
Solved! Go to Solution.
If the column was called Person ID then it would be
RequestSentDate =
VAR CurrentPerson = Sheet1[Person ID]
RETURN
LOOKUPVALUE (
Sheet1[Activity Date],
Sheet1[Activity], "REQUEST SENT",
Sheet1[Person ID], CurrentPerson
)
You need to include the unique identifier for the person in the LOOKUPVALUE
Apologies, where would that go in the string? I tried it in a variety of spots with no luck
If the column was called Person ID then it would be
RequestSentDate =
VAR CurrentPerson = Sheet1[Person ID]
RETURN
LOOKUPVALUE (
Sheet1[Activity Date],
Sheet1[Activity], "REQUEST SENT",
Sheet1[Person ID], CurrentPerson
)
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |