Power QueryExercises

Support tickets

Helpdesk tickets from a fictional telecom provider, some still open.

What's messy

Columns

ColumnTypeNote
TicketIDtext
Openeddate (yyyy-mm-dd)
Closeddate (yyyy-mm-dd)Blank if open
Prioritytext
Channeltext
Agenttext
Topictext

Try these

How to approach it

Set Opened and Closed to the date type first. The blank Closed cells become null, which is what you want for tickets that are still open. Days to close is Duration.Days([Closed] - [Opened]), and it returns null for open tickets on its own because arithmetic with null gives null. Don't replace those nulls with 0, or the average time to close will look better than it is. Then group by Channel and Priority with Count Rows, and count open tickets separately by filtering Closed to null.

Preview (first 8 rows)

TicketIDOpenedClosedPriorityChannelAgentTopic
T10002026-03-212026-03-23LowEmailIdrisOutage
T10012026-03-022026-03-03MediumEmailLenaOutage
T10022026-02-02nullLowPhoneOmarBilling
T10032026-05-112026-05-11LowEmailAmaraUpgrade
T10042026-04-10nullMediumChatLenaBilling
T10052026-04-152026-04-18MediumPhonePriyaOutage
T10062026-02-19nullUrgentChatDmitriOutage
T10072026-03-102026-03-11MediumEmailBaoUpgrade

All data is fictional. CSV cells that could be read as spreadsheet formulas are prefixed with an apostrophe.