Forum Discussion
Solved
SUMIF Help within one table
Hi all, Hope you can help me. I have a dataset which contains thousands of rows of invoice data. It may contain more than one row per invoice (because it's across multiple cost centres). I am ana...
garretc Try these:
Total Invoice Amt Column = VAR __InvoiceID = [Invoice ID] VAR __Table = FILTER('Table', [Invoice ID] = __InvoiceID) vAR __Result = SUMX(__Table, [Net Amount]) RETURN __Result < $25 Column = IF([Total Invoice Amt] > 50, TRUE(), FALSE())
garretc Try these:
Total Invoice Amt Column =
VAR __InvoiceID = [Invoice ID]
VAR __Table = FILTER('Table', [Invoice ID] = __InvoiceID)
vAR __Result = SUMX(__Table, [Net Amount])
RETURN
__Result
< $25 Column = IF([Total Invoice Amt] > 50, TRUE(), FALSE())Greg_Deckler Thanks so much for taking the time to look into this and reply - this worked a charm!
