Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Product Date of arrival Qty
A123 2023/01/01 20
A126 2023/01/01 5
A125 2023/01/01 4
A123 2023/01/05 26
A124 2023/01/01 17
A124 2023/01/05 15
A123 2023/01/07 20
How to create a measure that returns the total quantity that arrives daily for each product
Hi @Anonymous
SUM ( 'Table'[Qty] )
I Would like to aggregate it by arrival date
@Anonymous
It will be automatically aggregated. Just place product and date in a visual along with the SUM measure