Getting the last date without time

[Anonymous]

Hi,

I'm creating a measure which shows the last date.  I'm creating it with the following measure:

6_last_issue_date = maxx(table1, table1[issue_date].[Date])

It isn't clear in the picture but I'm using a card to show the date on.

I get the next result:

And I'm trying to get the next result:

I don't know where he gets the time from, because in my modeling tab of the data i put it on a format without time : dd/MM/yyyy

[Anonymous · Accepted solution]

@Anonymous Try wrapping your measure in format function

Measure = FORMAT(MAXX('Table','Table'[Date]),"MM/dd/yyyy")