Forum Discussion
Need help with Table Relationship
I have developed a Power BI Dashboard, with headcount table, joiners and leavers for a month.
The dashboard was working fine when I had just one month data on the dashboard (June) , now since I have added the second month data (Which has almost similar values such as employee ID,Employee name...etc), after the duplicate values came, the relationship which I had with the Headcount Table and the New Joiners which was (One to Many ) had been changed to Many to one and the values are not showing correctly.
Kindly let me know what relationship need to be set to get the dashboard show correct values ?, its just the joiners and leavers have this issue.
Is the New Joiners table expected to have duplicate values?
I mean how can an employee join twice, once in june and other in July?
If it is acceptable as per your data model, then you would have to look for some other field to create a relationship on.
Or else, create a bridge table with all the unique values of employee between New Joiner and Headcount and create a relationship of the two tables with the bridge table.
It's always better to have information related to employee in a separate table.
8 Replies
Is the New Joiners table expected to have duplicate values?
I mean how can an employee join twice, once in june and other in July?
If it is acceptable as per your data model, then you would have to look for some other field to create a relationship on.
Or else, create a bridge table with all the unique values of employee between New Joiner and Headcount and create a relationship of the two tables with the bridge table.
It's always better to have information related to employee in a separate table.
Try changing the direction of the relatioship to both.
I did try that, but it is not working
In that case I don't see why you are pointing that the cause is the relationship! Did you open power query and check for issues? Then did you DAX? Are your DAX formula correct? You see it could be different causes.
