Tracking Number of Days Between CVE Found/Remediated/Still Open,
Days to Remediation Calculations.pbix and Remediation Time Test.xlsx Still not there yet...close but not working as desired. What I need is to be able to figure out how many days a vuln has been open, either from first appearance if never remediated, or from its last appearance if it's been remediated previously and is still open. Nothing I have tried has solved that completely. Conditions of proper calculation: 1. If EndOcc = 0 from the date of its first BeginOccDate until today, the total # of days should be displayed. 2. If EndOcc = 1 and the CVE does not reappear, the total # of days should be 0 after that date. 3. If EndOcc = 1 and the CVE reappears in a later scan (new BeginOccDate), the day count should begin from there. I've created a CVESummaryTable that creates 4 calculated columns. This sets up the conditions for using the calculated columns. CVESummaryTable = SUMMARIZE( 'FactSourceCSVs', 'FactSourceCSVs'[CVE-HostKey-PluginOutputHash], "FirstBeginOccDate", MIN('FactSourceCSVs'[BeginOccDate]), "LastBeginOccDate", MAX('FactSourceCSVs'[BeginOccDate]), "FirstEndOccDate", MIN('FactSourceCSVs'[EndOccDate]), "LastEndOccDate", MAX('FactSourceCSVs'[EndOccDate]) ) These are used to count the days; cve_days_open seems to count the days a CVE is open, but doesn't count to today if there's no EndOcc = 1; that case results in days open = 0. cve_days_open = IF( ISBLANK(CVESummaryTable[LastBeginOccDate]), // Changed FirstBegin to FirstEnd to check for "No Remediations, Ever" DATEDIFF(CVESummaryTable[LastEndOccDate], TODAY(), DAY), DATEDIFF(CVESummaryTable[FirstBeginOccDate], CVESummaryTable[LastEndOccDate], DAY) + 0) cve_days_open_til_today counts to today, but doesn't take into account subsequent occurrences (i.e. per the attached .pbix: CVE-2024-1212 is opened on 2/22/2026, closed on 2/22/2026, and opened again on 4/5 but not closed, and days open is -42) cve_days_open_til_today = IF( ISBLANK(CVESummaryTable[LastEndOccDate]), DATEDIFF(CVESummaryTable[LastBeginOccDate], TODAY(), DAY), DATEDIFF(CVESummaryTable[LastBeginOccDate], CVESummaryTable[LastEndOccDate], DAY) // DATEDIFF(CVESummaryTable[LastBeginOccDate], TODAY(), DAY) + 0) I think cve_days_open_til_today is headed in the right direction. I need to figure out how to reset the day count when there's an EndOcc = 1 so that the next BeginOcc for that CVE is set to be the reference starting date.
Backlog average age by day
Hi, I need to calculate the average age of active tickets relatively to each day in my calendar table on the X axis. The way it is calculated is by adding +1 for each day where the ticket isn't solved (between start and end dates) and where the status is 0. Then the average is calculated on active tickets by date. Below an example of what I am trying to achieve : My datamodel is as follow : Thanks for the help.
DateDiff giving negative result when the next date-time is less than 24 hrs difference
This is for a calculated column. Whenever the [exit time] is the next day, but within 24 hours of [enter time], I get a negative result for minutes. All other aspects, except this, are working fine. Minutes = VAR _NonWorkingDays = CALCULATE( COUNTROWS('Calendar'), 'Calendar'[Day Type] <> "Work Day" ) VAR _WorkTimeElapsed = DATEDIFF(AuditLog[Enter_Time],AuditLog[Exit_Time], MINUTE) - (_NonWorkingDays* 24 * 60) RETURN _WorkTimeElapsed
Unable to create measure with DAX because my columns are not recognized.
From my DATA I have many columns with dates and null values. I want to use DATEDIFF so I can have the days betweens some columns, however when I use DAX it does not recognize my columns. The dates are in the correct format, I tried Co-pilot and the solutions does not apply. I really need some help to figure out how to fix it... Tese are the columns: DAX does not find the column...
DAX for datediff of values different rows
Hi, I am trying to use datediff in a column to gather the number of days between two events. I'm unable to produce the data. I think it something small I am missing, but I cannot figure it out. Here is a visual of my data. On the lefthand side, it is displaying each user, then a created receipts date and a created results date. For the item below, the Results date and Receipts date are two different events for the same user. I am trying to calculate the amount of time from Receipt to Results. I can provide a bit more information but hopefully this is enough to gather needed support. Thank you in advanceDatediff of several periods that fall within a range
Hi! I've been trying to get the total of days from different periods that fall within a range. I have a table with PERHH_PERSO (key for worker), with several PERHH_CONTRATO (number of contract), each with a PERHH_FEC_INI (start date) and PERHH_FEC_FIN (end date). For each contract, I establish a range from the Start_date to +364 days, in a calculated column (Day_end_period). I also have a calculated column for the Datediff of the actual contract (Actual_ctr_days) What I need is to count all days from all contracts of that same person (PERHH_PERSO) that fall within that range (from PERHH_FEC_INI to Day_end_period) Here is an extract of the table, with just one person selected: I'm not getting the logic of the calculation here... have tried several approaches but none is working. Help will be much appreciatted. Thanks!
