Forum Discussion
Creating a relationship with two date columns on one table
Hi All,
I have a table with two date columns, forecastdate and hiredate for employees. I want to be able to join both dates to my date table so i can show:
1) The forecasted amounts for the employee for a given month
2) the number of employees set to start for a given month
Is this possible?
Thanks!
Anonymous , if you want the same filter to work on both dates. Join those with a date table. Active/Inactive join will be created. Use userelation in measure for date of your choice
2 Replies
- amitchandak
Super User
Anonymous , if you want the same filter to work on both dates. Join those with a date table. Active/Inactive join will be created. Use userelation in measure for date of your choice