Distinct Count # of unique dates based on column with duplicates

Hi,

This should typically be done directly in the visual but if you must do it in the Query Editor, then this M code works

let
    Source = Excel.Workbook(File.Contents("C:\Users\mathu\Desktop\try.xlsx"), null, true),
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Data"}),
    #"Expanded Data" = Table.ExpandTableColumn(#"Removed Other Columns", "Data", {"Column1", "Column2"}, {"Data.Column1", "Data.Column2"}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Expanded Data", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Ticket Id", type text}, {"Ticket Closed Date", type date}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Ticket Id", Order.Ascending}}),
    #"Grouped Rows" = Table.Group(#"Sorted Rows", {"Ticket Id"}, {{"Count", each Table.RowCount(Table.Distinct(_)), type nullable date}})
in
    #"Grouped Rows"