Sepcial case of group by in M code

[klehar]

Hi,

Here is my dataset representing subset of actual data

Opp ID	Hardware Value	Order Date
OPE1	10	1/1/2020
OPE1	30	1/2/2020
OPE1	40	1/3/2020
OPE1	20	1/4/2020
OPE2	10	1/5/2020
OPE2	10	1/5/2020

I want to group the Order Values by Opportunity ID which is straight forward in Query Editor

However, if an opportunity has multiple dates then my ouput should show "Multiple dates" .

If an opportunity has only 1 date, then just mention the date.

So my output should look like this:

Opp ID	Hardware Value	Order Date
OPE1	100	Multiple Dates
OPE2	20	1/5/2020

How can i do this in M code?

[ryan_mayu · Accepted solution]

@klehar 

pls see the attachment below. Hope this is helpful