Forum Discussion
Filtering two separate date columns using only one active relationship to date dimension table
I'm trying to show metrics around turnover, and my business partners want to see a detailed look at who was hired or terminated within a given time period. I have been able to make calculated columns...
Hi tomjneal,
You may need to duplicate the sample data table. And establish a relationship between duplicated table and the date dimension table based on terminationed date.
Regards,
Yuliana Gu
Yuliana,
Thank you for your help! That worked for the date filter! I'm now able to filter both hire dates and termination dates. However, because the data is a copy, the "Department" and "Job Title" filters no longer function for my table containing terminated employees. When I try and create a relationship between those two data sets, I get an ambiguity error. I'd like to be able to put all of this information on the same page. Is that possible? Thank you so much for all of your assistance!
Very respectfully,
Tom Neal