Forum Discussion

Irwan's avatar
Irwan
Super User
3 years ago
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 ...
Need Help
Irwan's avatar
Irwan
Super User
3 years ago

hello Ahmedx 

 

thanks, it moved to new table, however the days are summed in the new table according to ID. Is there a way not to sum the days in the new table?

 

the expected new table is going to be like this 

IDDay
6000000002638298
6000000002638377

 

and also is it possible to automatically sorted "day" column in ascending order after it moved to new table?

 

Thank you again, really appreciated for the help.

Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try this

  • Irwan's avatar
    Irwan
    Super User
    3 years ago

    Hello Ahmedx 

     

    It works perfectly.

     

    Thank you and really appreciated for all the help.