Dax help

[Yaciineq]

Hi everyone,

I'm looking for a formula to show the date related to "accident avec arret". i d

Date	Type
31/01/2023	Soins
16/02/2023	Soins
22/02/2023	Soins
24/02/2023	Soins
03/03/2023	Soins
22/03/2023	Accident avec arrêt
17/01/2023	Soins
28/02/2023	Pandémie
08/03/2023	Soins

Thanks for your help

[Yaciineq]

No it didn't work, i want 22/03/2023 as result so i can show it on dashboard

Thank you

[DOLEARY85]

What are you getting instead? This is the result i get from that measure:

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Yaciineq]

I got this result, i don't know why i have the time ?

Thank you for your help

[DOLEARY85 · Accepted solution]

ah okay,

click on the measure in the data pane, then on the mearsure tools, select the format to short date:

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Yaciineq]

You roooock

Thanks a lot

[DOLEARY85]

No worries, happy to help 🙂

[DOLEARY85]

Hi,

try:  

Measure 6 = CALCULATE(MAX('Table (7)'[Date]),'Table (7)'[Type]="Accident avec arrêt")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍