SUMX explained.
Wyn Hopkins
![Wyn Hopkins]()
Wyn Hopkins
Leading a team that solves data challenges for companies and people Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Control costs, reduce risk and assist growth Microsoft MVP ??5 Million+ YouTube views
SUMX is a DAX function that can be used in an Excel Data Model (aka Power Pivot) to create a temporary column containing a calculation for each row which can then be summed.
This is a follow on from the last post on XLOOKUP v Power Query v Power Pivot
00:00 Intro
00:30 Recap
03:50 How does SUMX work
05:10 Writing a SUMX
We run Power BI and Excel Training in Australia and beyond
Check out my book "Power BI for the Excel Analyst"
Wyn
Financial Accountant @ DAT
1 年Do DAX Functions have all the excel functions as well ?