Retrouver date d'une valeur maximale

[AnneSo_59]

Bonjour,

je recherche une formule Dax pour me retourner dans une cellule la date de la valeur max enregistrée.

exemple :

Avec excel, j'utilisais une formule du style INDEX(BK374:BK404;EQUIV(MAX(BL374:BL404);BL374:BL404;0)).

Merci d'avance pour votre aide

[Anonymous · Accepted solution]

Hi, @AnneSo_59 

Please try the following DAX to create a Measure:

MAX_DATE = 
CALCULATE(
    MAX('Table'[Dates]),
    'Table'[Values] = MAX('Table'[Values])
)

I have attached the pbix file for this example below, hope it helps you.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Do a TOPN(1) based on the value then grab the Date from that row.

What should happen when multiple dates share the same maximum value?