Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
25 | |
23 | |
15 | |
11 |
User | Count |
---|---|
77 | |
61 | |
46 | |
18 | |
12 |