Forum Discussion
Calculating daily difference on network throughput
Hi 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.
here are a couple of examples based on your sample data. What is your expected outcome?
Sum:
Average:
