Email Count Monthly and Daily

[CelestialK3v]

Hi Im very new to Power Bi,

I connected an exchange mail box to power bi.

Im looking to create a report that would provide me with How many emails come in daily and monthly  as well as how many emails are sent daily and monthly

Please point me to the right direction 

[CelestialK3v]

thank you for your detailed response and pointing  me in the right direction with those links

Greatly appreciated. 

[v-yueyunzh-msft]

Hi, @CelestialK3v 

According to your description, you want to show How many emails come in daily and monthly  and the data source is the exchange .

For this, you have connected the data source. Then you need to convert the data in Power Query.

You need to extract the data you need to use in the data you get.

For more information, you can refer to :
Getting started with Query Editor in Power BI Desktop (sqlshack.com)

Analyzing your Microsoft Exchange Account Data with Power Query | Microsoft Power BI Blog | Microsof...

And then you can apply the data to Desktop and you can put the fields you need to show in the visual.

For more information,you can refer to :
Table visualizations in Power BI reports and dashboards - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly