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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.