Tracking and Enumerating Month To Month additions and deletions in Data Source

[Anonymous]

I have an SQL Data Source that contains the following columns: 

DateTime (Year, Quarter, Month, Day)

CustomerName

DeviceClass

DeviceName

At the end of each momth the daabase is appended with the current month's data. 

My goal is to track changes in the amount of devices and type of devices we are monitoring for each customer from month to month, and enumerate which devices were removed, and which were added. 

The month to month tracking of counts per customer is very simple and completed, but I am having a heck of a time figuring out how to show a table of removed and added devices month to month. 

Any suggestions or help would be greatly appreciated. 

[v-piga-msft]

Hi @Anonymous,

I'm a little confused about your sceanrio.

Please share some dummy data sample which could reproduce your scenario and your desired output so that I can understand your requirement better and get the solution.

Best Regards,

Cherry