Process Exchange data

[Markzolotoy]

I need to create a report that would have the following data:

I have never worked with Exchange data before. Can someone please share some wisdom here?

Thanks

[v-janeyg-msft]

Hi, @Markzolotoy 

So what can we help you? If you have problems, you can provide some sample data and your desired result, we can help you modify the measure or give you some advice.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[Markzolotoy]

I cannot provide any data. But I am sure if you access any Exchange data the structure will be the same.

[v-janeyg-msft]

@Markzolotoy  You only need to provide sample data (no need to be real).
And what's your problem?

[Markzolotoy]

Can you access Exchange data using your own email account? You will see the structure. The Exchange is pretty massive. Here is a problem to solve. How to find out whether a received email external or internal?

[v-janeyg-msft]

@Markzolotoy   

I don't have this data source, you can filter data when connecting to the data, select the column you want and add it to powerbi. As for how to judge whether the received mail is internal or external, it depends on whether the data can be used as a basis for judgment.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey

[amitchandak]

@Markzolotoy , do you want help on how to create the measures and visuals or how to get this data?

[Markzolotoy]

I can get Exchange data. I looked into it and without some help it is hard to understand how to get what I need. So, yes, measures and visuals.