DAX to find count of new Ids and deleted ids from a Timeseries data

[ganes]

I have a table called mytable with  2 colum's Report_Date and id.
Every week few new ids gets added and few gets deleted.
I want to get the count of ids that are newly added for each specific date  in the Report_Date colum.
I want to get the count of ids that are deleted for each specific date  in the Report_Date colum.

I have uploaded the raw data mytable.pbix file for reference here
https://onedrive.live.com/?authkey=%21AC7wjU%5FAXMZtThA&cid=82C96F93A7FA75E9&id=82C96F93A7FA75E9%211...


Below is the snap of Desired Result

[ganes]

Hi @CNENFRNL 

Could you please explain the logic you used. I tried to use same logic for last 3 days period instead of weekly but it is not returning correct values.

[CNENFRNL · Accepted solution]

[ganes]

Hi @CNENFRNL 

Thanks a lot. I am grateful for your help 🙂