Trying to summarize/sum data in a column on import

[MattEnerpac]

Hopefully I'm explaning this well, but i have a full listing of journal entry data by line for the calendar year. I'm trying to either create a separate table (or column, i guess) that will sum up all lines for each journal entry for me to put into a visual, so i can have side by side visuals showing how many entries are made by line and how many are made per entry, if that makes sense. I can figure out how to do this in ACL and other programs, but am hoping PowerBi can do this for me. 

[v-eqin-msft · Accepted solution]

Hi @MattEnerpac

If you want to get sum varying amounts for each journal entry, Ihave built a simply data sample:

You could create a measure:

Measure = CALCULATE(SUM('Table'[varying amounts]),ALLEXCEPT('Table','Table'[Journal entry]))

Or use the summarize type of SUM as the below shown.

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattEnerpac]

Hey Dave,

My end goal is to take a listing of journal entries that are currently provided by line, and basically subtotal them to obtain their total value - I.E. if I have 14 line items of journal entry #2503 that are for varying amounts, i'd like to have a report that shows just one line for journal entry #2503 but a total of all of the line amounts. Does that make more sense?

[davehus]

Can you provide and example of what it is you're trying to achieve?