topic Re: Max & If/Only in creation of Measure in App Development

Max & If/Only in creation of Measure

SingSing16 — Thu, 12 Jan 2023 15:05:32 GMT

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:

I need to gain this result :

Status for the latest DateOfChange for each ProjectName

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

agigliotti — Thu, 12 Jan 2023 15:28:00 GMT

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 — Fri, 13 Jan 2023 14:51:19 GMT

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 — Fri, 13 Jan 2023 15:27:56 GMT

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 — Tue, 17 Jan 2023 10:17:26 GMT

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