Summery summation by unique date

[2019]

I have a table for the whole years, where I have multiple entries (Value) for the same dates , I want to have a summery table by using DAX to have a daily summery just like how it shown in table 2

This is a sample table

Table 1

Date	Value
01-01-18	3000
01-01-18	4000
01-01-18	18000
01-01-18	12000
02-01-18	45000
02-01-18	13000
03-01-18	8000
01-02-18	3000
01-02-18	43000
01-03-18	2000
01-03-18	48000
02-03-18	1000

I want to have the result like

Table 2

Date	Value
01-01-18	37000
02-01-18	58000
03-01-18	8000
01-02-18	46000
01-03-18	50000
02-03-18	1000

[v-yuezhe-msft · Accepted solution]

@2019,

As other's post , create a new table using DAX below.

Table2 = SUMMARIZE(Table1,Table1[Date],"value",SUM(Table1[Value]))

Or you can use "Group By" feature in Power BI Desktop query editor.



Regards,
Lydia

[Anonymous]

Hi, You can try this https://docs.microsoft.com/en-us/dax/summarize-function-dax