Picking values and adding them together

[M-M-P]

Hi

I have a dataset with over 5000 data points. It is structured like this:

I would like to add values together that share a unique Timestamp but where UnitName is different. Like this:

Example:

Timestamp is 1/1/2019 1:00:00 AM

84,6 + 17,4 + 66,8 = 168,8

I hope someone can help. Thanks

[v-frfei-msft · Accepted solution]

Hi @M-M-P ,

To create a calculated column as below.

Column = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Timestamp]= EARLIER('Table'[Timestamp]) ))

[M-M-P]

Hi @v-frfei-msft 

Thank you for your suggestion. I appreciate it 🙂

[M-M-P]

@HotChilli  & @Greg_Deckler 

Thank you very much for your suggestions. I will try them out 🙂

[Greg_Deckler]

See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395.... This would be for a column.

[HotChilli]

Keep it simple and pull Timestamp and Value on to a table.

IF Value is set to SUM in the field well, you will get the answer you want