I have a column that I grouped by tracking number. I want to display how many items in the shipments went to each student.
I had a column that had the shipped dates so when I grouped by tracking date, I got duplicate dates I didn't need.
***Note: I changed my date field to a text column in another step. I was doing something else with the data, like using power automate to write the outputs to a CSV and I didn't want to deal with the whole "Format Date and Time" in Power automate. ++
Here's the cheat FX:
{"WhatYouWantToNameYourColumn", each Text.Combine(List.Distinct([YourColumnName])," "), type nullable text}
Turns this:
Into This!
So later I could do this. :)