johnny51981
Active Member
- Joined
- Jun 8, 2015
- Messages
- 409
I have 3 total columns, Customer Job ID, Daily #, and Daily Date. I would like to update this M code to combine all distinct Daily #s sorted in order by Daily Date. Any assistance on updating this would be greatly appreciated.
Power Query:
= Table.Group(#"Filtered Rows", {"Customer Job ID"}, {{"Daily IDs", each Text.Combine(List.Distinct([#"Daily #"]),"/"), type nullable text}})