cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MasterData77
New Member

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.

MasterData77_1-1683699500056.png


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

1 REPLY 1
Tahreem24
Super User
Super User

@MasterData77  Create a DAX COlumn like below:

Column = CALCULATE(MAX('Table'[Manager]), FILTER('Table','Table'[Proj ID]=EARLIER('Table'[Proj ID])))
Tahreem24_0-1683704169780.png

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors