DAX Forumula to sum quantities by Order No.

[Ice1341]

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

[Ashish_Mathur]

Hi,

Drag Order No to the Table visual and write these measures

Total = sum(Data[Quantity])

Order dt = min(Data[OrderDate])

Hope this helps.