Re-repaired into 30 days

Question

Dear all,&nbsp;I have a table and I would like to mark in a column RFR30 all serial number that was repaired 30 days from current fix date:Fail Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| Serial Number | RFR3001-Nov-2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 (on 10-oct-2018 this serial number was also repaired)01-Nov-2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;10-Oct-2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01-Sept-2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Someone know how to do that?Tks for help

zubair_muhammad · Accepted Answer

Anonymous
&nbsp;
Do you just want to count the number of instances.? in That case you can use this calculated column
&nbsp;
RFR30 =
CALCULATE (
    COUNTROWS ( Table1_2 ),
    FILTER (
        Table1_2,
        [Serial Number] = EARLIER ( [Serial Number] )
            &amp;&amp; [Fail Date] &lt; EARLIER ( [Fail Date] )
            &amp;&amp; [Fail Date]
                &gt; ( EARLIER ( [Fail Date] ) - 30 )
    )
)

Forum Discussion

Re-repaired into 30 days

1 Reply

Related content

Day to Day average

Data Days | Data Days Your Way

Data Days | Create

Data Days | Full Schedule 2026

Cases per Day Calculation