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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
thos123
Regular Visitor

how I compare budget and sale price

I had data,

first table include time,customer,product,sale,sale price.

second table include time ,sale team,target price

third table include sale,sale team

 

how I can compare between sale price and target price?

 

Thanks.

2 ACCEPTED SOLUTIONS
thos123
Regular Visitor

Yes you can approach as you have shown in the link.

 

Another method is - http://www.powerpivotpro.com/2012/01/salesbudget-integrating-data-of-different-grains/

 

If you come from a relational database background it can be hard to get your head around (it was for me anyway). There should be no direct joins/links between your data tables, instead data tables should link to common dimension/lookup tables.

 

Edit - In your eample I think you will need to add product to table 2 (I cant see a common link at the moment). You can then create product and date/period look up tables and link table 1 and 2 accordingly. Use the look up table values as the row and column items in your analysis.

View solution in original post

4 REPLIES 4
thos123
Regular Visitor

Yes you can approach as you have shown in the link.

 

Another method is - http://www.powerpivotpro.com/2012/01/salesbudget-integrating-data-of-different-grains/

 

If you come from a relational database background it can be hard to get your head around (it was for me anyway). There should be no direct joins/links between your data tables, instead data tables should link to common dimension/lookup tables.

 

Edit - In your eample I think you will need to add product to table 2 (I cant see a common link at the moment). You can then create product and date/period look up tables and link table 1 and 2 accordingly. Use the look up table values as the row and column items in your analysis.

thos123
Regular Visitor

I don't have target price for product . I have only sale price.
Target price is goal for team sale.

Thanks for your comment.
fitnesspowerbi
Advocate II
Advocate II

If you wanted to compare the traget and sale price for a given product you would need "product" in both tables. Once in both tables you can use a clustered bar chart with product on the shared axis and sale price and target price in the column values. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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