Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
2019
Helper II
Helper II

Summery summation by unique date

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

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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.
1.PNG2.PNG


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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.
1.PNG2.PNG


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.