Forum Discussion
Solved
LOOKUPVALUE with multiple values and current row
Really stuck here on DAX syntax--could use some help. I have a list of tasks for people to complete. Each task has multiple people assigned to it--and the work is performed in sequence (meaning p...
Hi van_r
Your approach should work. See it in the attached file with the data provided. If you get that multiple values error that means that your table has more than one due table for a person-order combination.
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
AlB
Community Champion
Community ChampionHi van_r
Your approach should work. See it in the attached file with the data provided. If you get that multiple values error that means that your table has more than one due table for a person-order combination.
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |