Forum Discussion

jaynesa's avatar
jaynesa
Icon for Helper II rankHelper II
6 years ago

Calculating a total while ignoring duplicate values in a column

I'm currently loading and transforming my table "Payroll" into Power Query.  And I want to be able calculate a true annual total for the Payroll, without double counting.  The data load comes out lik...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

jaynesa 

Try something like this

sumx(Summarize(Table,Table[organization],table[location], Table[Category] ,Table[year],Table[Qtr],"_1",max(Table[Total location Payroll])),[_1])

jaynesa's avatar
jaynesa
Icon for Helper II rankHelper II
6 years ago

So, let's say the year changes, or some other column like "Category".  For exampe, if the year changes to 2020, how can I make sure the new column calc only calc's 2020?  How will it know to not include 2019?