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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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.

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

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors