Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
66 | |
64 | |
57 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |