Summarizing Issue

[Anonymous]

Hello Community, 

I think this issue is pretty simple but I'm struggeling a bit and won't spend more time on it: 

yy_delete = 

SUMMARIZE(ALLSELECTED(Transactions),Transactions[order],Transactions[delivery_Date], Transactions[booking_Date],"h",DATEDIFF(Transactions[delivery_Date],Transactions[booking_Date],HOUR))

I have dublicated orders in the summarize-output which I'd like to avoid by only keeping the lates booking_Date. In the example above the desired output should look like this: 

A   |    25.02.2022 07:15:00    | 01.03.2022 16:00:00   | 105

Thank you in advance! 

[amitchandak]

@Anonymous , Try a measure like

Measure =
VAR __id = MAX ('Transactions'[order] )
VAR __date = CALCULATE ( MAX('Transactions'[booking_Date] ), ALLSELECTED ('Transactions' ), 'Transactions'[order] = __id )
return
CALCULATE ( sumx(Transactions, DATEDIFF(Transactions[delivery_Date],Transactions[booking_Date],HOUR)), VALUES ('Transactions'[order] ),'Transactions'[order] = __id,'Transactions'[booking_Date] = __date )

[Anonymous]

Hello,

thank you! 

This worked for me: 

var _vTableTmp = 
SUMMARIZE(ALLSELECTED(Transactions)
 ,Transactions[order]
 ,Transactions[delivery_Date]
 ,"MaxBookingDate"
 ,max(Transactions[booking_Date])
)

var _vTable = 
SUMMARIZE(_vTableTmp 
 ,Transactions[order]
 ,Transactions[delivery_Date]
 ,[MaxBookingDate]
 ,"vDelta",
 DATEDIFF(Transactions[delivery_Date],[MaxBookingDate],HOUR)
)