cancel
Showing results for
Did you mean:
Highlighted
Continued Contributor

## Network traffic per second

Hello all!

I have a question about how to approach a problem I have with a calculation.

My data looks like the following:

 Time SourceAdress DestinationAdress Bytes 10:05 10.10.10.10 99.99.99.99 10 10:10 11.11.11.11 66.66.66.66 20 10:15 11.11.11.11 67.67.67.67 10 10:20 11.11.11.11 66.66.66.66 12 10:25 12.12.12.12 77.77.77.77 24 10:30 10.10.10.10 77.77.77.77 30

It is connected to a database that updates these fields automatically. Now what I would like to achieve is to calculate how much bytes per seconds/ per minute and per 10 minutes are sent.

I am not sure how to approach this so it would be greatly appreciated if someone could help/ give me a push in the right direction!

(tips about how to visualise this type of data are also very welcome)

L.Meijdam

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: Network traffic per second

Hi @LMeijdam,

Based on my assumption, you could create measures like below, and display results in card visual.

`sent bytes per seconds = SUM(table8[Bytes])/DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),SECOND)sent bytes per minute = SUM(table8[Bytes])/DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)sent bytes per 10 minutes = SUM(table8[Bytes])/(DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)/10)`

If it doesn't meet your requirement, please provide more description about how to calculate "bytes per seconds/ per minute and per 10 minutes are sent". It would be better you can show desired putput with examples.

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Microsoft

## Re: Network traffic per second

Hi @LMeijdam,

Based on my assumption, you could create measures like below, and display results in card visual.

`sent bytes per seconds = SUM(table8[Bytes])/DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),SECOND)sent bytes per minute = SUM(table8[Bytes])/DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)sent bytes per 10 minutes = SUM(table8[Bytes])/(DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)/10)`

If it doesn't meet your requirement, please provide more description about how to calculate "bytes per seconds/ per minute and per 10 minutes are sent". It would be better you can show desired putput with examples.

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Continued Contributor

## Re: Network traffic per second

I am sorry the question was not really clear, however the answer you provided worked perfectly for me!

One small thing I was wondering if the measure "Sent bytes per 10 minutes" shouldnt be like this instead:

`sent bytes per 10 minutes = SUM(table8[Bytes])/(DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)*10)`

Perhaps I misunderstood the measure, but I got the feeling that you would get the result of 1 minute / 10 instead of 10 whole minutes.

Thanks!

Best regards,

L.Meijdam

Microsoft

## Re: Network traffic per second

Hi @LMeijdam,

Yes. As you said, if the result should be 1 minute / 10 instead of 10 whole minutes, the measure should be changed to:

`sent bytes per 10 minutes = SUM(table8[Bytes])/(DATEDIFF(MIN(table8[Time]),MAX(table8[Time]),MINUTE)*10)`

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Continued Contributor

## Re: Network traffic per second

This was exactly what I was looking for thanks for the help.

Best regards,

L.Meijdam

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors