cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Regular Visitor
Highlighted

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
Highlighted
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. 

Highlighted
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.
Highlighted
Regular Visitor
Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors