The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi all,
I am new to DAX and I am working with a sample Contoso Database available from the link below:
https://github.com/sql-bi/Contoso-Data-
Generator/releases/download/v1.0.0/Contoso.100K.bak.
I am trying to create a DAX expression that performs a cumualtive total of Quantity on Customer Full Name.
Customer data is from Data Customer table and Quantity is coming from Data Order Rows. These tables are joined by
Data Customer (Customer Key) - Data Orders (Customer Key) - Data Order Rows (Order Key)
My Expresisons is from the Running total is:
RT= VAR IND=[RANKING]
RETURN
CALCULATE (SUM
- [Customer] - Full Name is in Data Customer table and derived as :
User | Count |
---|---|
14 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
28 | |
18 | |
13 | |
7 | |
5 |