Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
i need to apply the below medule in power bi as it accumulative sum product
i try Dax but EARLIER ( 'Table'[Number A] ) ) can't select 'Table'[Number A] ) and show error
Have you read my assumptions? If the assumptions are not correct please advise what is.
Hi @HRawash2
Assuming Number A and Number B are columns in a data table ('Table') and you are looking for a calculated column the pkease try
Accumulated =
VAR T =
FILTER ( 'Table', 'Table'[Number A] <= EARLIER ( 'Table'[Number A] ) )
RETURN
DIVIDE (
SUMX ( 'Table', 'Table'[Number A] * 'Table'[Number B] ),
SUMX ( 'Table', 'Table'[Number B] )
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 12 | |
| 11 | |
| 10 |