Get only last change per day where multiple changes per day

[darkobrown]

I have a change history table. The table looks as this: 

As you can see the last 2 rows are in the same day. This messes my calculations up when i want to sum it up per day. So i need only 1 entry per day (the latest). 

How can i achieve with dax that I only get 1 entry per day where mutliple entries per day exist ? (only when its the same field) 

[darkobrown · Accepted solution]

That was not the expected Result. 

But I managed to solve the problem with a collegue. 

Here is the Solution for anyone intrested: 

1. I created a new Column where I formated the 'created' column into "DateAsInteger" :

createdDateAsInt = FORMAT(change_history_SP[created],"YYYYMMDD")

 2. I created another column as following: 

Only1ValueperDay Remaining Sp = 
VAR latestdate= CALCULATE(MAXX(change_history_SP, change_history_SP[created]), ALLEXCEPT(change_history_SP,change_history_SP[createdDateAsInt], change_history_SP[id]))
return 
IF(change_history_SP[created] = latestdate && change_history_SP[field]= "Remaining SP", change_history_SP[newstring] )

By this solution I get only the latest change if there are more than 1 change for the field "Remaining SP". 

And then did the same for the Field "Story Points". 

Now it looks like this: 

[vk_pbi]

Hi, 

I am not sure about your calculation (sum, average etc), but you can use the MAXX to iterate each row in the table and take the MAX date&time.

Hope this will help you. 

Or else please share some more details to write DAX for you