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.
Hi
I am trying to create a cumulative column from the Total and Index column in the table SalesByCustomer.
What is wrong in my formula?
Thanks Giora
Solved! Go to Solution.
Hello, @gtamir
Correct formula below
Cumulative Total =
SUMX (
FILTER (
SalesByCustomer,
SalesByCustomer[Index] <= EARLIER ( SalesByCustomer[Index] )
),
SalesByCustomer[Total]
)
Thanks but it has a problem.
Ah ha. Now I fixed it. Thanks
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |