cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
AUDISU
Resolver II
Resolver II

Create Summarize Table Using Dim and Fact Tables

Hi power bi experts.

I am tring to create a summarize table in power bi. 
My sample tables are.

Calender Table

DateYearMonth
1/01/202320231
2/01/202320231
3/01/202320231
4/01/202320231
5/01/202320231
6/01/202320231

 

Product Table

Product IDProdct Name
1AA
2AB
3AC
4AD

 

Sales Table

DateProduct IDQtyAmount
5/01/202315120
10/01/20232250
12/01/2023110240
20/01/202335150

 

I need to create a Month to Date summary table as follow.

Expected Table

DateProductQtySales
31/01/2023AA15360
31/01/2023AB250
31/01/2023AC5150

 

Can anyone help me to solve this problem please.

Thanks.

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

Please find attached the PBI file.

Ashish_Mathur_0-1691970584374.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur 
Thank you for your reply.
I need to create this using Summarize Table.
Because I need to read this data in Power Automate.

Thanks.

Dims
Helper III
Helper III

SUMMARIZE( Sales, Calender[Date], Product[Product Name], "Qty", SUM(Sales[Qty]), "Sales", SUM(Sales[Amount]) )

@Dims 

Thank you for your reply.
This gives me daily details. I need month to date.
Thanks

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors