Max & If/Only in creation of Measure

[SingSing16]

I have issue with creation of formula  including Max and If / Only.

I want prepare appropratiate measures related to the latest DateOfChange

This is source table:

ProjectName	Status	DateOfChange
ProjectA	Closed	2022-12-31
ProjectA	Open	2019-12-12
ProjectA	On hold	2020-05-17
ProjectB	Open	2021-06-05
ProjectB	Cancelled	2023-01-13
ProjectB	On hold	2022-07-15
ProjectC	In progress	2023-01-02
ProjectC	Open	2022-01-07

I need to gain this result :

Status for the latest DateOfChange for each ProjectName

Result should be as below. Please support me with this,

ProjectName	Status	DateOfChange
ProjectA	Closed	2022-12-31
ProjectB	Cancelled	2023-01-13
ProjectC	In progress	2023-01-02

[agigliotti · Accepted solution]

Hi @SingSing16 ,

In a table with ProjectName as dimension:

Add measure "Status" as below:

=FirstSortedValue( Status, -DateOfChange )

Add measure "DateOfChange" as below:

=Max( DateOfChange  )

I hope it can helps.

Best Regards

[SingSing16]

Unfortunately I did not receive any value under colmn with this formula =FirstSortedValue( Status, -DateOfChange ).

Do you have any idea why?

Thank your for your reply.
Best Regards

[rui24 · Accepted solution]

Hi SingSing16 

Make sure you put ProjectName as Dimension and other as Measures.

Dimension: ProjectName

Measure: FirstSortedValue(Status,-DateOfChange)

Measure: Max(DateOfChange)

The final result right regarding what you needed.

Best Regards

[SingSing16]

Hello  @agigliotti , @rui24 , this solution works after double check. Thank you 🙂