Forum Discussion

king2005r's avatar
king2005r
Icon for Helper III rankHelper III
5 years ago
Solved

Vulnerabilities status report

Hi I have a table with monthly vulnerabilities, Plugin ID, and Host IP, I need to do the below measurement  : 1- Get repeated monthly vulnerabilities 2- Get the count of the new vulnerabilities 3...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi king2005r ,

     

    Create 2 calculated columns as below:

    Repeated = 
 var _previous=CALCULATE(MAX('Table'[Plugin ID]),FILTER('Table','Table'[Host]=EARLIER('Table'[Host])&&'Table'[Open Date]<EARLIER('Table'[Open Date])&&'Table'[Plugin ID]=EARLIER('Table'[Plugin ID])))
 Return
 IF(_previous=BLANK(),"Not repeated","Repeated")
    Count of Plugin vulnerability = 
var _count=CALCULATE(COUNT('Table'[Plugin ID]),FILTER('Table','Table'[Plugin ID]=EARLIER('Table'[Plugin ID])&&'Table'[Host]=EARLIER('Table'[Host])&&'Table'[Open Date]<=EARLIER('Table'[Open Date])))
Return
_count

    And you wil see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

king2005r's avatar
king2005r
Icon for Helper III rankHelper III
5 years ago

Hi v-kelly-msft 

 

sorry for this, I want to have the below if you can support in this further :

1- Any vulnerabilities don't exist in the last scan month vulnerabilities consider as closed in all previous months 

2- Any vulnerabilities exist in the last scan month consider as open in all previous months