Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :