Forum Discussion

Sachid's avatar
Sachid
Regular Visitor
7 years ago
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...
General Comment
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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,

     

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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,