Count Rows when Date is added on Table2

[Anonymous]

I am new to this forum and am power bi, desperately looking for DAX where. Please help!! Thanks in advance

I have 2 tables: Table 1 and Table 2, when Dates are added then the ID(3 and 4 below case) disappears from Table2 now I need to count how many move from table 2 to table1.

Table1 

ID  Titles  PlannedDate ReleaseDate  Path
3    Test3 6/1/2021       6/1/2021       Case1
4    Test4  8/1/2021      null                Case1

Table2
ID  Titles PlannedDate ReleaseDate  Path
1   Test1   null               null               Case2
2   Test2   null               null               Case2
3   Test3   null               null               Case2- (Case1)
4   Test4   null               null               Case2- (Case1)
5   Test5   null               null               Case2

[Anonymous · Accepted solution]

Ended up adding another column to the table to recognize the move. I couldn't implement it on Power BI but the extra column(checkbox) helped.

[edhans]

You cannot with the info you have given. When Power BI refreshes, it deletes the entire model and recreates it, so it doesn't know records "moved" from one table to another. (That isn't actually what it does - over simplification, but the point stands).

The only way you can count the records would be one of the following:

1. your data source loads the old table to another place, then you could use something like EXCEPT() to see what is in the old table vs the new. Whatever is missing must have moved.
2. Your data moving from one table to the other needs a date for the date of movement, then you filter based on that date - today's date for example.