QuestionQ74
VerifiedPrepare dataYou have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiData that stores the following data.

You need to create a column named FirstPickupDateTime that contains the first value of each hour from tpep_pickup_datetime, partitioned by payment_type.
How should you complete the query?
Select
TaxiData | sort by tpep_pickup_datetime asc, payment_type asc | extend FirstPickupDateTime = (tpep_pickup_datetime, 1h, 0m, payment_type prev(payment_type))
Community Discussion