Forum Discussion

MasterData77's avatar
MasterData77
New Member
3 years ago

Find the latest value for specific category - Column

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

https://drive.google.com/file/d/1lcQ2AgnqBdVPEXXgbVhswZr9SAq2fq9J/view?usp=sharing

Need Help

1 Reply

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    3 years ago

    MasterData77  Create a DAX COlumn like below:

    Column = CALCULATE(MAX('Table'[Manager]), FILTER('Table','Table'[Proj ID]=EARLIER('Table'[Proj ID])))