Forum Discussion
Calculating daily difference on network throughput
Hi all,
We're using Power BI for something different than what it normally is used for - network analysis. The principle of course stay the same.
My issue is that I have multiple countries, which consists of multiple regions in those countries, which contain a different number of servers, where each server have a certain amount of throughput. I have the following values in my table:
date | server name | network throughput | region | country
I'm trying to find a method how I can differentiate between the network utilization on a daily, weekly and monthly basis, and it can be either expressed as a value or a percentage. Currently I have created a calculation whereby all the servers in a region are summed together to give a total throughput per region per day, so that is also an option to decrease the amount of filtering to be added. Ideally it would be great to have these done per server.
Here is an example of the type of data:
| Date | server name | throughput | Region | Country |
| 01-May-20 | server10.ams | 6.65502165 | Amsterdam | Netherlands |
| 01-May-20 | server11.ehv | 0.466185961 | Eindhoven | Netherlands |
| 01-May-20 | server2.zrh | 8.566098994 | Zurich | Switzerland |
| 01-May-20 | server4.urh | 4.746088086 | Utrecht | Netherlands |
| 01-May-20 | server11.ams | 2.380500813 | Amsterdam | Netherlands |
| 01-May-20 | server3.ldn | 11.64876059 | London | United-Kingdom |
| 01-May-20 | server1.bhm | 14.45529932 | Birmingham | United-Kingdom |
| 01-May-20 | server1.brt | 0.773632127 | Bucharest | Romania |
| 01-May-20 | server2.dbn | 0.731045812 | Dublin | Ireland |
Thanks in advance for any help on this.
Regards,
NjR
15 Replies
That sounds like standard Power BI functionality. Where exactly are you stuck?
Anonymous , with date table you can do any kind of comparison
Power BI — YTD
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — QTD
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Power BI — WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
Power BI — Day Intelligence
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9Hi amitchandak lbendlin ,
Thank you for your feedback. I've tested all the date formulas (which is super cool btw), but I'm getting stuck everytime on the same issue - whenever I'm trying to manipulate the throughput based on date, I'm getting an error back stating that: "a singe value for column 'throughput' in table 'network' cannot be determined." And then it continues about suggestions as to aggregating the data to get to a single result.
But, I already have a single result - per server which belongs to a specific region in a specific country I have 1 value per day.
What am I missing then?
you're missing the concept of a filter context. Just because you see a single value (date) on a visual doesn't mean there is actually physically a single row of the extended table behind it.
So go with the aggregations (sum, average,whatever it appropriate) and use these aggregations as your formula input.
lbendlin , can you perhaps provide me an example?
Whenever I try to use filters, I end up having to apply filtering to the point where I can only filter a single server (from the list I provided), instead of Power BI automatically picking the unique server and its throughput, and comparing it with another day.
