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.
Hello,
Need DAX formula to group order no. column by order no. and sum by quantity column.
Order No_ | Quantity | OrderDate |
SO8550 | 80 | 1/2/2023 |
SO8550 | 80 | 1/2/2023 |
SO3550 | 30 | 12/2/2022 |
SO69966 | 150 | 2/3/2023 |
SO4411 | 260 | 2/5/2023 |
SO3321 | 250 | 2/12/2023 |
SO33545 | 100 | 3/1/2023 |
Should sum quantity like this:
Order No_ | Quantity | OrderDate |
SO8550 | 160 | 1/2/2023 |
SO3550 | 30 | 12/2/2022 |
SO69966 | 150 | 2/3/2023 |
SO4411 | 260 | 2/5/2023 |
SO3321 | 250 | 2/12/2023 |
SO33545 | 100 | 3/1/2023 |
Hi,
Drag Order No to the Table visual and write these measures
Total = sum(Data[Quantity])
Order dt = min(Data[OrderDate])
Hope this helps.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |