Forum Discussion

hpatel24779's avatar
hpatel24779
Icon for Helper II rankHelper II
1 year ago

identifying continuous dates per person in new column

Hi All,   I want to firstly thank all members that have helped with my queries so far and hope to continue getting support which will help me improve on my Power BI skills.    My latest query is ...
Need Help
Show and Tell
Tips and Tricks
hpatel24779's avatar
hpatel24779
Icon for Helper II rankHelper II
1 year ago

thank you lbendlin and p45cal for you input.

 

Anonymous this seems to be what i am looking for however, when applying this to my model it is taking too long because my data has thousands of rows and i only supplied small example. is there a workaround to speed up the calculations?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

    • ronrsnfld's avatar
      ronrsnfld
      Icon for Super User rankSuper User
      1 year ago

      What is the meaning of the absence of End Date?

       

      Looking at your linked worksheet:

      If it means the task is ongoing, then why aren't All of the Required Start Date for 9816 = 4/1/2023.

       

      Please clarify.

       

      • p45cal's avatar
        p45cal
        Icon for Solution Supplier rankSolution Supplier
        1 year ago

        Depending on the OP's answer, I may have to revisit my offering…

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      I don't see thousands of rows in your sample file.