Getting familiar with creating tables in dax & adjusting filter contexts (pretty interesting stuff). Now, I’ve seem to got most of my calculations right, but now I need to retrieve a string from a row for which I already have the correct calculation. Basically, I’m looking for the current/last milestone & next milestone per project (for which I can in fact retrieve the dates from a filtered table, but not the actual name from the Task column)
I’ve also added a sample powerbi file with all calculations included.
Edna - Time & Milestones.pbix (169.3 KB)