What is the best way to join Sales vs Sales Targets

[Cry0niX]

We're often requried to show sales/pipeline compared to our target.  Previously I have done this using a seperate table for the sales targets and created a composite key which joins on to the sales table.

Is this the best way to achieve my goal?  Or is it better to append the sales targets to the sales/opportunity tables?

[bhanu_gautam · Accepted solution]

@Cry0niX , You can try method given in below post

https://community.fabric.microsoft.com/t5/Desktop/Sales-Target-Issue/m-p/3512555

[Cry0niX]

thanks @bhanu_gautam I will take a look and give it a go 🙂