Forum Discussion
Helper ICount emails sent during non-working hours
Hi, caznaran
If you are using Outlook mailbox, you can get the corresponding data through the PBI connector, then you can count the data you want.
Like this:
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Usercaznaran , This video talks about how to deal with business hours. See if that can help to get opposite of it https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Helper IThanks for the help. I actually want to know if there is a datasource (like O365 Analytics) for all emails being sent from a tenant. I do not want to read the contents but just basic stats like number of emails sent during non-working hours.