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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
SuperJK5088
Frequent Visitor

Monthly Quota Tracking with multiple criteria

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!

PBI Help.png

1 ACCEPTED SOLUTION
DataNinja777
Super User
Super User

Hi @SuperJK5088 ,

You can achive your required output in the following manner. 

 

  1. 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.  
  2. Create dimension tables for Product Type and Region and create relationships with Sales fact table and Monthly Quota fact tables. 
  3. Create calculate calendar table and create a relationship with the sales fact table date column.

DataNinja777_1-1721029373650.png

The resultant output is as shown below:

DataNinja777_0-1721029325909.png

I attach an example pbix file.

Best regards,

View solution in original post

2 REPLIES 2
DataNinja777
Super User
Super User

Hi @SuperJK5088 ,

You can achive your required output in the following manner. 

 

  1. 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.  
  2. Create dimension tables for Product Type and Region and create relationships with Sales fact table and Monthly Quota fact tables. 
  3. Create calculate calendar table and create a relationship with the sales fact table date column.

DataNinja777_1-1721029373650.png

The resultant output is as shown below:

DataNinja777_0-1721029325909.png

I attach an example pbix file.

Best regards,

ryan_mayu
Super User
Super User

what's the expected output based on the sample data you provided?

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.