analyse total number of e-mails sent per day

[qwertzuiop]

I am very new to Power BI, but I have to present my work in a few days.

As you can see in the table, we have the collums:

- transportID

- created

- amountOfEmails

What I need to present is the total number of mails sent per day in a list and as a bar chart.

Can anyone help me?

PS: At the moment I only got this.

Thank you very much.

qwertzuiop

[AlB · Accepted solution]

Hi @qwertzuiop 

1. Create an additional column with the date only: 

CreationDate = INT( Table1[Created] )

and and convert to Date type

2. Place Table1[CreationDate] in the rows of a table visual and in the axis of a bar chart

3. Place this measure in both visuals:

NumEmails =
SUM( Table1[amountOfemails] )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[qwertzuiop]

@AlB thank you so much for the solution.

I wish you all the best!

qwertzuiop