Forum Discussion
Get just one date from multiple rows with the same date
I've found a way to solve it for my specific case, matching up the term date with the last day with client date (since they should only match when the employee has been termed anyway). Thanks for the replies all!
Anonymous well if you don't have termination date by department, you cannot achieve that anyhow so not sure how you are planning to do it?
parry2k I do have termination date by department actually, it is shown as the lastDayWithClient column. Sorry for not explaining it thoroughly! What is most important here for me right now is actually empLocation, where I need to be able to count and break out attrition by empLocation which has multiple categories. This is why I wanted to get a column which shows the hire and termination date only once per person so that once I broke it out by location, it would not overcount attrition.
Hi Anonymous
You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
