How to identify new, closed and repeated data about an object month by month

[Syndicate_Admin]

Good afternoon

I have almost no experience with BI, I have worked only flat data and normal graphs, and on this occasion what I would like to do is to be able to compare data, punctually from results of vulnerability analysis.

In the data that I charge as an example, what is identified is:

1. two different scans numbered as 34 and 35
2. 6 different hosts
3. new vulnerabilities in the first scan
4. repeated vunerabilities in the second scan
5. vulnerabilities closed in the second scan (no longer appear)
6. new vulnerabilities in the second scan
7. New systems (IP)
8. Outgoing (IP) systems

What I would like precisely is to be able to graph those previously numbered conultas, I have seen that it can be done with DAX but my knowledge is almost zero in this subject.

https://docs.google.com/spreadsheets/d/1eXTj5FWafXYvoQsV2T0X2wXCgRyFFz3h/edit?usp=sharing&ouid=10771...

I would appreciate someone could help me

[amitchandak]

@Syndicate_Admin , You can refer how the logic I used in customer Retention, for new, lost and retain. Check if that can help

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...