Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
9 months ago
Solved

Help with DAX power BI

I have a detention sheet, where the order of the columns is as follows: Column A: Start Date Column B: Line (machine) Columnca C: Start time (what time the arrest began) End 😧 Time column (wh...
  • v-hashadapu's avatar
    v-hashadapu
    7 months ago

    Hi Syndicate_Admin , Thank you for reaching out to the Microsoft Community Forum.

     

    Please refer below sample spreadsheet snap:

    Detenciones_Limpias snap:

     

    Detenciones_Con_Producción snap:

     

    Please refer attached .pbix file and output snaps and share your thoughts:

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
9 months ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    9 months ago

    The link requires access. please check.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      9 months ago

      My apologies, I just checked and I have left the file as public.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        9 months ago

        Your data seems to be missing the End Date column - how are you planning to handle events that run across midnight?

         

        You may also want to invest in a calendar table.

         

        Identifying the "previous" record is expensive in your scenario (multi million row fact table) and will likely have to be done outside of Power BI. For example with an index column in Power Query.