Forum Discussion
How to join multiple date fields from fact table to Dim Date table
Hi topkapi
From the above, I understand that you are trying to generate a line chart to show the number of people who joined or left the organisation as displayed over a certain time frame (x axis). If this is the case, you can use USERELATIONSHIP in a measure for the date fields that have the relationships that are not active.
Let me know if you dont come right.
Display multiple date fields on line graph
You are welcome. If my reply helped, please mark it as Answer.
But I am still unable to provide a single dim - date on x-axis to see trend to both.
Hi topkapi
From the above, I understand that you are trying to generate a line chart to show the number of people who joined or left the organisation as displayed over a certain time frame (x axis). If this is the case, you can use USERELATIONSHIP in a measure for the date fields that have the relationships that are not active.
Let me know if you dont come right.
Display multiple date fields on line graph