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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
AUDISU
Resolver III
Resolver III

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.

DiKi-I
Helper IV
Helper IV

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

@DiKi-I 

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

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!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.