Here is my dataset representing subset of actual data
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:
How can i do this in M code?
Go to Solution.
pls see the attachment below. Hope this is helpful
Proud to be a Super User!
View solution in original post
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!