Dates Table Relationship

[Sachid]

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. 

[v-cherch-msft · Accepted solution]

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,