get one time the date that is multiplied in a single column

[alexcollin24]

I all,

I have this situation here where I want to get only one time the date that is multiplied in my column just like this :

There are amounts that follows the date and I only want a single time, for instance, 12/20/2017 so I can easely do a sum of those amounts in my dashboard. Can someone help me please. Thanks

[v-yulgu-msft · Accepted solution]

Hi @alexcollin24,

You can create a calculated table using SUMMARIZE function:

New Table= SUMMARIZE(TableName,TableName[DateKey],"Sum Amounts",Sum(TableName[Amount]))

Best regards,
Yuliana Gu