Hi PBI Experts 🙂
I have the following tables and I need to calculate if the stores are meeting monthly quota. How do I do that? I also need to pick multiple months without messing up the baseline. Please help - thank you!
Hi @SuperJK5088 ,
You can achive your required output in the following manner.
- Create the sales fact table by unpivoting the month columns using Power Query so that the actual sales by month will be in one column instead of 3 columns.
- Create dimension tables for Product Type and Region and create relationships with Sales fact table and Monthly Quota fact tables.
- Create calculate calendar table and create a relationship with the sales fact table date column.
The resultant output is as shown below:
I attach an example pbix file.
Best regards,
Hi @SuperJK5088 ,
You can achive your required output in the following manner.
- Create the sales fact table by unpivoting the month columns using Power Query so that the actual sales by month will be in one column instead of 3 columns.
- Create dimension tables for Product Type and Region and create relationships with Sales fact table and Monthly Quota fact tables.
- Create calculate calendar table and create a relationship with the sales fact table date column.
The resultant output is as shown below:
I attach an example pbix file.
Best regards,
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
