Forum Discussion
Solved
Need Advice: How to Calculate Date Diff between Two Exact Event
Hello Power BI Experts, I need an advice about my dataset. Below is my data. My need is to find the next row that contains the exact string (description) for example "replace" with the exactly ...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiQZUXnY1lqz0ovDw?e=ufVd4q
Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.
hello Ahmedx ,
here is sample of the data to make it simpler.
The expected result is
1. 298 (from 16-Dec-19 till 9-Oct-20), days difference between line 2 and line 9.
2. 377 (from 9-Oct-20 till 16-Dec-19), days difference between line 9 and line 13.
Those three events have exactly same description and equipment number.
| 1 | 600000001974 | Replace pulley | 8-Oct-19 |
| 2 | 600000002638 | Replace motor | 16-Dec-19 |
| 3 | 600000083190 | Replace pulley | 27-Jan-20 |
| 4 | 600000002693 | Replace pulley | 12-May-20 |
| 5 | 600000002616 | Replace pulley | 26-May-20 |
| 6 | 600000083190 | Replace pulley | 6-Jun-20 |
| 7 | 600000002638 | Replace pulley | 7-Jul-20 |
| 8 | 600000003106 | Replace pulley | 21-Sep-20 |
| 9 | 600000002638 | Replace motor | 9-Oct-20 |
| 10 | 600000002693 | Replace pulley | 29-Jul-21 |
| 11 | 600000002645 | Replace pulley | 19-Aug-21 |
| 12 | 600000002624 | Replace pulley | 15-Oct-21 |
| 13 | 600000002638 | Replace motor | 21-Oct-21 |
Thank you and appreciated with the help.