Forum Discussion

shankyy7227's avatar
shankyy7227
Frequent Visitor
8 years ago

Average by Month

 

 

 

 

 

 

 

 

 

Hello 

 

I am tying to calculate Avg Hours between Entry and Exit by exit date and exit time for report month (based on all exits in report month).

 

Please help me

 

Thanks

 

Need Help

3 Replies

  • BKirsch12's avatar
    BKirsch12
    Resolver II
    8 years ago

    I would suggest you make a month column. Then use the Group By and choose the appropriate field you want to group by. Then choose average for the hours between enty and exit.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi shankyy7227,

     

    I would suggest you create a new date table and establish relationship between [Exit Date] and [Date] which is from the new table. Then drag the 'DateTable'[Date] into a table and expand the hierarchies of Date. Use the month and average the [Hours between Entry and Exit].

     

    Best Regards,

    Dale