Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting the last date without time

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's avatar
    Anonymous
    6 years ago

    Anonymous Try wrapping your measure in format function

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous Try wrapping your measure in format function

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