Forum Discussion

Roma28's avatar
Roma28
Frequent Visitor
7 years ago

Calculating Working hours

Hi,    i want to calculate the working hours that passed between the arrive of an email and the final answer to the client. I found a very good script at this link https://community.powerbi.com/t5...
Need Help
Tips and Tricks
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Roma28 ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

 

Roma28's avatar
Roma28
Frequent Visitor
7 years ago

Hi Frank v-frfei-msft 

 

thanks for the help !! I have sensible data in the original file, so i created a new one with just index, start & end date

 

 

https://luissmy.sharepoint.com/:u:/g/personal/luca_romano_studenti_luiss_it/EeACcVnEIxNHiuCL6fmcpc8BpaiAgy9cju0viyZEu7GXYA?e=zJ4pL1 --> powerBi file

 

https://luissmy.sharepoint.com/:x:/g/personal/luca_romano_studenti_luiss_it/EdF8jYf2S8hIltb8ROG0vVkBXI8rnTLmRYMmnKU7ff8wMQ?e=buF2ee --> excel table