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 ...
Need Help
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