Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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 ) ) )
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 ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |