Forum Discussion
Anonymous
6 years agoNot applicable
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
- Anonymous6 years ago
Anonymous Try wrapping your measure in format function
Measure = FORMAT(MAXX('Table','Table'[Date]),"MM/dd/yyyy")
1 Reply
- AnonymousNot applicable
Anonymous Try wrapping your measure in format function
Measure = FORMAT(MAXX('Table','Table'[Date]),"MM/dd/yyyy")