DAX to return sum of most recent values by ID

[limpfisch]

Hi there

I have a table set up like this

I wish to create a table visual which takes the sum of the most recent values for each ID for every rounded date time. So the desired output would look like this

I am using direct query mode.

Any help is much appreciated.

Thanks

[Jihwan_Kim]

Hi,

I assume the table name is "Data".

Please try the below DAX measure if it suits your requirement.

Expected result dax measure: =
SUMX (
    WINDOW (
        -1,
        ABS,
        -1,
        ABS,
        SUMMARIZE ( Data, Data[ID], Data[DateTime], Data[Value] ),
        ORDERBY ( Data[DateTime], ASC ),
        ,
        PARTITIONBY ( Data[ID] )
    ),
    Data[Value]
)

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.