Forum Discussion
Solved
Dax help
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
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 👍
7 Replies
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 👍No it didn't work, i want 22/03/2023 as result so i can show it on dashboard
Thank you
