how I compare budget and sale price

[thos123]

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.

[thos123 · Accepted solution]

Can I do like this in power BI?
http://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/

Thanks.

[thos123 · Accepted solution]

Can I do like this in power BI?
http://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/

Thanks.

[itchyeyeballs · Accepted solution]

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]

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]

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.