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:

     

     

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
7 months ago

Thank you very much for your attendance, I will comment point by point.

In "Detenciones_Limpias" I compare with the real spreadsheet and indeed I see that it merges times but they do not match the base sheet. (I will leave a reference image)
Regarding "Detenciones_Final" The phenomenon is the same. In any case, in some cases it is applied well but the result is not the desired one, as seen in the previous example or in the following one:

He ended up adding 30 minutes of snack that was skipped.


Finally, in "Detenciones_Con_Producción" I see that you have added columns that come from the production database, however, those added data do not represent much use to me. What I wanted to retrieve from the database was the SKU or squad so that I could associate the arrest with a particular product.

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
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: