Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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)
Thanks in advance,
L.Meijdam
Solved! Go to Solution.
Hi @Anonymous,
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
Hi @Anonymous,
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
Hi @v-yulgu-msft,
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
Hi @Anonymous,
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
Hi @v-yulgu-msft,
This was exactly what I was looking for thanks for the help.
Best regards,
L.Meijdam
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
109 | |
109 | |
93 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |