Forum Discussion
Using lookupvalue within summarize
I have a set of of data that has a list of projects and the dates at which they hit set milestones - I want to be able to understand which milestone is next for each project. I have generated a sampl...
Works fine on my end. Check the file out
Hi Anonymous
Try this:
Summary =
ADDCOLUMNS (
ADDCOLUMNS (
SUMMARIZE ( 'Table'; 'Table'[Project] );
"Next Milestone Date"; CALCULATE ( MIN ( 'Table'[Event Date] ); 'Table'[Status] = "U" )
);
"Next Stage"; LOOKUPVALUE (
'Table'[Stage];
'Table'[Event Date]; [Next Milestone Date];
'Table'[Project]; [Project]
)
)AlB Thanks for the response.
Although I agree/understand the logic. Your solution generates the error, "a table of multiple values was supplier where a single value was expected'
Works fine on my end. Check the file out