cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shankyy7227 Frequent Visitor
Frequent Visitor

Average by Month

tst.PNG

 

 

 

 

 

 

 

 

 

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

 

3 REPLIES 3
BKirsch12 Member
Member

Re: Average by Month

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.

Community Support Team
Community Support Team

Re: Average by Month

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Average by Month

Hi @shankyy7227,

 

Can you mark the proper answer as a solution please?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.