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)
Thanks for supplying a PBIX
I think you must have been so close because you had already solved the Dates… Basically I reused your code and added the function VALUES and an additional Filter condition, so lookup Values in the resources.
Thanks for the feedback. I’ve worked with a number of “specialists” before but never really been too impressed. Demand for PowerBi is increasing, can’t & not interested in doing it all myself so am looking to bring a few people together to get things going. Never done something this remote though, but I guess that’s how things work. So may need to setup a Teams meeting with a few people. You’ve got my details. Not sure how to get in touch with other from here.
Hi,
Melissa pointed me in your direction. As for your comments on specialists, PBI covers a wide area, (I am a consultant like you), and just like before in Excel you will find people specialised in certain areas, my specialty is Logistics where others will be a specialist in Finance etc… Deeper knowledge in each discipline will be available through experienced people in their own right.
Happy to communicate about commercial opportunities.
Paul.
I’m thrilled to share the fantastic progress we’ve made in our latest endeavor. Currently, we’ve successfully navigated through the initial phases, ensuring seamless communication and top-notch collaboration among team members.
Our next milestones are even more exciting! The team is gearing up for an innovative approach in the upcoming phase, integrating cutting-edge technologies to enhance efficiency. Stay tuned for some groundbreaking developments that will undoubtedly propel us closer to our project goals.
Let’s celebrate our achievements so far and look forward to the exciting journey ahead! #ProjectManagement#Milestones#TeamSuccess