cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Re-repaired into 30 days

Dear all,

 

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         | Serial Number | RFR30

01-Nov-2018            1                   1 (on 10-oct-2018 this serial number was also repaired)

01-Nov-2018            2                

10-Oct-2018             1                 

01-Sept-2018            3                 

 

Someone know how to do that?
Tks for help

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

@RafaelNevoa

 

Do you just want to count the number of instances.? in That case you can use this calculated column

 

RFR30 =
CALCULATE (
    COUNTROWS ( Table1_2 ),
    FILTER (
        Table1_2,
        [Serial Number] = EARLIER ( [Serial Number] )
            && [Fail Date] < EARLIER ( [Fail Date] )
            && [Fail Date]
                > ( EARLIER ( [Fail Date] ) - 30 )
    )
)
Regards,
Zubair


View solution in original post

1 REPLY 1
Super User I
Super User I

@RafaelNevoa

 

Do you just want to count the number of instances.? in That case you can use this calculated column

 

RFR30 =
CALCULATE (
    COUNTROWS ( Table1_2 ),
    FILTER (
        Table1_2,
        [Serial Number] = EARLIER ( [Serial Number] )
            && [Fail Date] < EARLIER ( [Fail Date] )
            && [Fail Date]
                > ( EARLIER ( [Fail Date] ) - 30 )
    )
)
Regards,
Zubair


View solution in original post

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors