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.
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])
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |