Hello!I've created a basic model with simplified my requirements.I have a table, which contains the project ID with the specified stage of every project.This is how my sample model looks like.
In my final model, I have only 3 first columns.
I have to achieve a column like "Latest Project Manager" via the DAX column - this can't be measure or Power Query.
I've attached my sample .pbix
@MasterData77 Create a DAX COlumn like below:
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.