Forum Discussion

AUDISU's avatar
AUDISU
Icon for Resolver III rankResolver III
3 years ago

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 Date Year Month 1/01/2023 2023 1 2/01/2023 2023 1 3/01/2023 2023 ...
Need Help
DiKi-I's avatar
DiKi-I
Icon for Post Partisan rankPost Partisan
3 years ago

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

AUDISU's avatar
AUDISU
Icon for Resolver III rankResolver III
3 years ago

DiKi-I 

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