Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |