topic Re: DAX to find count of new Ids and deleted ids from a Timeseries data in DAX Commands and Tips

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

Anonymous — Fri, 17 Mar 2023 19:26:02 GMT

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%21142&parId=root&o=OneUp

Below is the snap of Desired Result

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

CNENFRNL — Sat, 18 Mar 2023 02:00:36 GMT

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

Anonymous — Sat, 18 Mar 2023 07:37:10 GMT

Hi CNENFRNL

Thanks a lot. I am grateful for your help 🙂

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

Anonymous — Sat, 18 Mar 2023 11:20:21 GMT

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.