The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a table containing invoice data. Invoices are broken down by item/item amount.
I want to create a column in this table that shows the invoice total based on the invoice number of the calculated row.
I created the below table in Excel using a sumif formula which looks at the range of the invoice column, criteria equals the column/row being evaluated, and the sum range is the amt column.
How do I do this in PowerBI?
Example table (see desired results in pink):
ID | Invoice | Item | Amt | Inv Total |
1 | 1001 | A widget | 0.50 | 4.50 |
2 | 1001 | B widget | 0.50 | 4.50 |
3 | 1001 | C widget | 1.00 | 4.50 |
4 | 1001 | D widget | 1.00 | 4.50 |
5 | 1001 | E widget | 1.50 | 4.50 |
6 | 2001 | A widget | 0.50 | 1.00 |
7 | 2001 | B widget | 0.50 | 1.00 |
8 | 3001 | A widget | 0.50 | 2.00 |
9 | 3001 | B widget | 0.50 | 2.00 |
10 | 3001 | C widget | 1.00 | 2.00 |
Solved! Go to Solution.
@lpriceFTW Excel to DAX Translation - Microsoft Power BI Community Look at the S category for SUMIF equivalent.
Think your answer is here
https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/m-p/134279
Thanks this worked.