Forum Discussion

demonfc's avatar
demonfc
Microsoft Employee
7 years ago
Solved

Time difference HELP

Hello,    I am looking to determine the difference in hours on a given day for a salesman who works that day. The expected result would be essentially be a seperate table with the salesmans name, t...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI demonfc,

     

    In my opinion, I'd like to suggest you extract hour part from datetime column. Then you can create time table with time value from 0:00 to 23:00, build relationship from time table to new 'hour' column.

     

    Column formula:

    Hour = TIME(HOUR([Date]),0,0)

    Calculate table formula:

    Time table = GENERATESERIES(TIME(0,0,0),TIME(23,0,0),TIME(1,0,0))

     

    After these steps, you can use time table column as axis, origin table column as value column create visuals with summarize original table values.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI demonfc,

 

In my opinion, I'd like to suggest you extract hour part from datetime column. Then you can create time table with time value from 0:00 to 23:00, build relationship from time table to new 'hour' column.

 

Column formula:

Hour = TIME(HOUR([Date]),0,0)

Calculate table formula:

Time table = GENERATESERIES(TIME(0,0,0),TIME(23,0,0),TIME(1,0,0))

 

After these steps, you can use time table column as axis, origin table column as value column create visuals with summarize original table values.

 

Regards,

Xiaoxin Sheng