Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
pls see the attachment below. Hope this is helpful
Proud to be a Super User!
pls see the attachment below. Hope this is helpful
Proud to be a Super User!
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |