Forum Discussion
Solved
Dates Table Relationship
I have A table whenr in there are two date columns Joining_Date and leaving_Date with leaving date with null values for the active people. I have created A date table and want to map a relation ship to the two columns and try to plot on a stacked bar chart for each year the people joined and people left. Can any one help me with this the relationship if noe working when i am trying to map the date table date to the two columns.
Hi Sachid
You may link the tables and then create measures with USERELATIONSHIP Function.For further,please refer to this article.
JoinedPeople = CALCULATE(COUNT(Table1[Name]),USERELATIONSHIP('Date'[Date],Table1[Join Date]),Table1[Status]="Active")LeftPeople = CALCULATE(COUNT(Table1[Name]),USERELATIONSHIP('Date'[Date],Table1[Left Date]),Table1[Status]="Active")Regards,
1 Reply
Hi Sachid
You may link the tables and then create measures with USERELATIONSHIP Function.For further,please refer to this article.
JoinedPeople = CALCULATE(COUNT(Table1[Name]),USERELATIONSHIP('Date'[Date],Table1[Join Date]),Table1[Status]="Active")LeftPeople = CALCULATE(COUNT(Table1[Name]),USERELATIONSHIP('Date'[Date],Table1[Left Date]),Table1[Status]="Active")Regards,