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 

 

one last question, can we move the data in "Count of Days" into separate table or column accordingly to its "ID" and then sort it out in ascending order?

 

Thank you again.

  • 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.