Combine multiple Rows

[Anonymous]

Hey,

I have a question I am struggling with for a little while now. 

I current have some data that looks like this: 

Each row has the same timestamp and ID since it is generated at the same time. This is basically a price calculation. The aim is to have only one row per ID and timestamp. 
I grouped by max date to get only the latest results. I also followed https://community.powerbi.com/t5/Desktop/Sum-of-Certain-Rows/m-p/871024 this solution to get the numbers as sum in one row. The problem here is that it keeps every row and removing duplicates results in having one row, yes, but the calculated colomn is not working properly after the removal. 

I need this results but with only one row per ID and max. timestamp. 

Can´t figure it out and help is much appreciated. 

Kind regards 

Molly

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.
Sample data:

Column:

Column = CALCULATE(MAX('Table'[Mod]),FILTER('Table',[ID]=EARLIER('Table'[ID])))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[ryan_mayu]

could you pls provide the sample data (not the screenshot) and the expected output?