Change formula of a measure

[ibrahimsharaf]

Hello guys, I have a column which contained dates with times, I transformed it to only contain dates, then I created a measure to get the min date using this formula "Measure = MIN(Dates)", but it keeps getting the time with the date, I only want the date, can you help?

[Vvelarde · Accepted solution]

hi @ibrahimsharaf

In modeling Menu you can change the date format of your measure.

[v-ljerr-msft · Accepted solution]

@ibrahimsharaf

---

---

but it keeps getting the time with the date, I only want the date, can you help? 

In addition to @Vvelarde's solution, using FORMAT function within the Measure can also meet your requirement. Please refer to the formula below:

Measure = FORMAT ( MIN ( Dates ), "Short Date" )

 Regards

[Vvelarde · Accepted solution]

hi @ibrahimsharaf

In modeling Menu you can change the date format of your measure.