Forum Discussion
Solved
LOOKUPVALUE gone wild
Hi,
I am building out some measures and hit a snag, appreciate any advice.
- Measure One looks like this: A-Parts Finish = LOOKUPVALUE(Tasks[EndDate],Tasks[KeyMilestoneType],"A-Parts")
- This works great.
- Mesure Two looks like this: A-Parts Health = LOOKUPVALUE(Tasks[TaskStatus],Tasks[KeyMilestoneType],"A-Parts")
- This works great
- Measure Three looks like this: A-Parts PercentDone = LOOKUPVALUE(Tasks[PercentDone],Tasks[KeyMilestoneType],"A-Parts")
- This one throws an error: A table of multiple values was supplied where a single value was expected
This doesn't make sense to me, any thoughts?
