Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
For this example below, I wante a DAX measure that returns the change over date from defective to repaired for each ID(the part don't have a unique ID). I tried many formulas but they didn't work for me.
Thanks for your help.
Date | Part | ID | Designator | change over date |
20-avr | A | 5022120 | repaired | 20-avr |
19-avr | A | 5022120 | defective | 20-avr |
18-avr | A | 5022120 | defective | 20-avr |
17-avr | A | 5022120 | defective | 20-avr |
20-avr | B | 3288286 | repaired | 19-avr |
19-avr | B | 3288286 | repaired | 19-avr |
18-avr | B | 3288286 | defective | 19-avr |
17-avr | B | 3288286 | defective | 19-avr |
20-avr | D | 5235789 | repaired | 19-avr |
19-avr | D | 5235789 | repaired | 19-avr |
18-avr | D | 5235789 | defective | 19-avr |
Solved! Go to Solution.
@09 , try a new column like
minx(filter(Table, [ID] =earlier([ID]) && [Part_number] =earlier([Part_number]) && [Designator] ="repaired"), [Date])
Thank you for your help!
It works.
@09 , try a new column like
minx(filter(Table, [ID] =earlier([ID]) && [Part_number] =earlier([Part_number]) && [Designator] ="repaired"), [Date])
User | Count |
---|---|
53 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |