Sum of values of same date

[krishb1414]

Hi Everyone,

I need to do sum of count column and result will be shown as final column.

If there is any 2 same dates then count column will do sum else returns count column value.

Can anyone help ?

[DOLEARY85 · Accepted solution]

Hi,

try this:

Column = CALCULATE(sum('Table'[count]),ALLEXCEPT('Table','Table'[Date]))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[v-stephen-msft · Accepted solution]

Hi @krishb1414 ,

You could create a calculated column.

final = CALCULATE(SUM('Table'[count]),FILTER('Table',[Date]=EARLIER('Table'[Date])))

Best Regards,

Stephen Tao

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

[DOLEARY85 · Accepted solution]

Hi,

try this:

Column = CALCULATE(sum('Table'[count]),ALLEXCEPT('Table','Table'[Date]))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[AmiraBedh]

Based on your dataset :

DateTable =
DATATABLE (
"Date", DATETIME,
"count", DOUBLE,
{
{ "01/08/2023", 0.5 },
{ "01/08/2023", 0.5 },
{ "02/08/2023", 0.5 },
{ "02/08/2023", 0.5 },
{ "03/08/2023", 0.5 },
{ "04/08/2023", 0.5 },
{ "04/08/2023", 0.5 }
}
)

Create a summarized table like below : 

SummarizedTable =

    SUMMARIZE (

        DateTable,

        DateTable[Date],

        "Final", IF(COUNTROWS(DateTable) > 1, SUM(DateTable[count]), MIN(DateTable[count]))

    )