Dax query to get latestdatetime from date column

[Yogesh907641T]

Need help

I have date column which consist date & time value, this date value has value of data inserted table, data is inserted in table multipale times in a day so i have same date but time is different.

Example :  time & data row inserted count.

8/2/2022 3:31:37 AM +00:00

71627

8/2/2022 3:11:46 AM +00:00

123

I want to write a dax which give me information for respective time. I have connected data through direct query mode.

[tamerj1]

Hi @Yogesh907641T 

is this a text format? What is the + 00:0071627?

[Yogesh907641T]

Below is sample of data

customercode	customername	envtype	dataTime	prem
123	ABC	qa	6/22/2022 14:53	16828908.55
123	ABC	uat	6/22/2022 14:53	256508373.1
123	ABC	prod	6/22/2022 14:53	266719635.1

[tamerj1]

@Yogesh907641T 
Thank you. would you please advise the expected output based on this sample.

[Yogesh907641T]

we need a filter data based on latest ingestion time. need to show result as below.

data is loading multiple time in a day so we have duplicate date & data but time changed everytime so we need data to show only for latest time "prem" & "Countc".

some time "prem" & "countc", remain same for day, it may change any time if transction happens.

Time                                                                        prem                         CountC
002 IMT prod 6/22/2022 2:53:29 PM                     266719635.05                 15 

for more details you can call me 9923310100, or email thoratyogesh1@gmail.com

[Yogesh907641T]

yes this is text format

[tamerj1]

@Yogesh907641T 
 What is the + 00:0071627?