Find first values per earliest Date

[DBrito79]

Hello,
I have a table called "Cycles" and i need a dax column with the value (the name) of CYCLES[Status Atual] for the earlier/maximum [FirstMatingDate] and for each CYCLES[ID&FARM]

I am trying this formula:

EarliestStatusAtFirstMatingDate =

CALCULATE( MAXX(

FILTER( ALL(CYCLES),

CYCLES[FirstMatingDate] = CALCULATE( MAX(CYCLES[FirstMatingDate]),

ALLEXCEPT(CYCLES, CYCLES[ID&FARM])

)),

CYCLES[Status Atual]

)))

But it returns the me the status name with the last alfabethical order.

Can you help me with this?
Thanks in advance

[Anonymous · Accepted solution]

HI @DBrito79,

You can try to use the following measure formula if it suitable for your requirement:

EarliestStatusAtFirstMatingDate =
VAR _lastDate =
    CALCULATE (
        MAX ( CYCLES[FirstMatingDate] ),
        ALLSELECTED ( CYCLES ),
        VALUES ( CYCLES[ID&FARM] )
    )
RETURN
    CALCULATE (
        MAX ( CYCLES[Status Atual] ),
        FILTER ( ALLSELECTED ( CYCLES ), CYCLES[FirstMatingDate] = _lastDate )
    )

Regards,

Xiaoxin Sheng

[DBrito79]

It worked... Thanks a million, Sorry for the delay ansewring . Regards

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...