Table visualization/ display value based on max date

Raj_251891 , All the columns other than Table[Date & Time], do this all column. Create a measure like this and use in Table visual

Max Ref No= lastnonblankvalue(Table[Date & Time], max(Table[Ref No]))

Hey Raj_251891 ,

make sure that the column Date & Time has the data type Date/Time assigned ,

I changed the data type accordingly using Power Query:

I chose the settings below:

After that I created a calculated column using DAX (doing this, allows to filter the data using a slicer).

I used this DAX statement:

is latest = 
var __currentDateTime = [Date & Time]
var __maxDateTime = CALCULATE( MAX( 'Table'[Date & Time] ) , 'Table' )
return
IF( __currentDateTime = __maxDateTime  , 1 , 0 )

Finally my table will look like this:

Hopefully, this is what you are looking for.

Regards,

Tom

Hi  Raj_251891 ,

Here are the steps you can follow：

1. Create Calculation Table.

Table 3 = FILTER('Table',
'Table'[Date & Time]=MAXX('Table','Table'[Date & Time]))

2. Result.

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello

You can download my solution file from here.

I hope this helps.