Average by Month

[shankyy7227]

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

[v-jiascu-msft]

Hi @shankyy7227,

Can you mark the proper answer as a solution please?

Best Regards,

Dale

[v-jiascu-msft]

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

[BKirsch12]

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.