Forum Discussion
Creating performance gauge based on a separate table
Hi all,
I have 2 tables,
First table consist of the sales person gross sales ($)
Second table holds the data on what is their expected gross sales, and constitution to define their performance within a given range.
How can I link this 2 tables up to gauge the sales person performance.
Currently, I have input the figures in DAX, however, the performance gauge might change from time to time thus I require it to be in another table.
5 Replies
Please post samples from each table, and cleanse the data if needed to not post sensitive figures. Do the tables have an 'Employee Key' or other value that uniquely identifies each employee? It would also help if you mock up what you are trying to make the final visual look like...
hi naoki
You need to create a relationship between two tables.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
If you still have the problem, please share some simple sample data and your expected output.
Regards,
Lin
What that I am trying to achieve is this.
- Obtain the no of months as of today the sales person is with the company (
- Match the number of months they are with us to the expected sales month.
- In expected sales table if the number of months the sales person is with us equal or lesser than X months than it will return X month expected sales.
- Otherwise if it is more than X but less than Y it will return Y expected sales.
hi, naoki
Sample data and expected output would help tremendously.
Please share some simple sample data.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Regards,
Lin
