Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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 )
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)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |