Date conversion

[topazz11]

Hello,

I need help a DAX to get maximum (latest) date as below? 

There are multiple timestamps on the same date and I need to get a max date from the same date timestamps.

Thank you!

[Greg_Deckler · Accepted solution]

Try:

Column =

VAR __Date = INT([Column1])

RETURN

DATE(YEAR(__Date),MONTH(__Date),DAY(__Date))

Set the display to just the date and not date and time.

[v-chuncz-msft · Accepted solution]

@topazz11 

You may use the following DAX to add a calculated column.

Column =
VAR d = Table1[Timestamp].[Date]
RETURN
    IF (
        RANKX (
            FILTER ( Table1, Table1[Timestamp].[Date] = d ),
            Table1[Timestamp],
            ,
            DESC
        ) = 1,
        Table1[Timestamp]
    )

[amitchandak]

Try one of  two can give

max = maxx(filter(table, table[timestamp].date = earlier(table[timestamp]).date ),table[timestamp])
max = maxx(filter(table, table[timestamp].date = earlier(table[timestamp].date) ),table[timestamp])

[Greg_Deckler]

Also, this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814

[Greg_Deckler · Accepted solution]

Try:

Column =

VAR __Date = INT([Column1])

RETURN

DATE(YEAR(__Date),MONTH(__Date),DAY(__Date))

Set the display to just the date and not date and time.