Power BI & Excel Power PivotKansas City

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Help with summing detail data that involves time

  • 1.  Help with summing detail data that involves time

    Posted Aug 31, 2020 02:44 PM
    Hello everyone,

    I am new to Power BI, about a year now.  I have taken a few classes through Centriq and I know a bit about DAX functions now.

    Here is my problem.  I have a time reporting table that is detail by work order, employee, machine, day and time.  The time by run, setup, clean, wash, repair, etc.  I need to perform some type of calculation to get a 1 line summary by work order, employee, machine for the day(s) time(s).  Below is what my detailed PBI report looks like.  Any help anyone can give me would be much appreciated.

    Thank you,

    Jim Rubino
    Data Analyst
    Tension Envelope
    Kansas City MO