Table Relations - counting the missing rows

Hi Mardo,

So your requirement is equal to achieve rows only appear in table1 and rows only appear in table2, right?

Merge(Left Anti and Right Anti) can meet your requirement, click query editor->Merge Queries->Select join kind as left anti or right anti.

After merged, you get two tables that contains only people left the company and only people joined the company.

Finally, apply and create a measure using count(table) to calculate the number of people.

Regards,

Jimmy Tao

Mardo,

You should be able to use the following;

https://msdn.microsoft.com/en-us/query-bi/dax/datediff-function-dax

https://msdn.microsoft.com/en-us/query-bi/dax/today-function-dax

This will calculate the date you need.