Forum Discussion
Best Approach Question - Merge Tables or Connect Together?
Hi mariner84
I need to know the relationship among table 1 and other tables.
As i know, table 2 shows employees' hired date, table 3 shows term date.
What is the realistic meaning of table 1?
Do you want to show the numbers of employees in a company during a data range with the waterfall visual?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Table 1 is essentially the list of employees who were still at the company at the end of 2018.
Table 2 is the hires this year and Table 3 is the exits so far.
Below is a quick example I just created to get an idea of what it would like look with data slicers if possible.
Yes, I just want to show the rise and fall, with the ability to use data slicers using my org levels and also dates if possible.
Thank you for responding to my request!
https://www.dropbox.com/s/4sdwsbrhayo8dg1/PBI-Help.pbix?dl=0
I've attached a sample data file if anyone can help...