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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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 III
Helper III

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors