topic Re: analyse total number of e-mails sent per day in DAX Commands and Tips

analyse total number of e-mails sent per day

qwertzuiop — Mon, 21 Oct 2019 06:41:28 GMT

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 — Mon, 21 Oct 2019 07:36:54 GMT

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 — Mon, 21 Oct 2019 07:57:14 GMT

AlB thank you so much for the solution.

I wish you all the best!

qwertzuiop