Forum Discussion
How do I create a new table that sums multiple columns based on the date in another column?
Hello everyone reading this question. I apologize if this has been answered in some other post, but I wasn't able to find exactly how to do what I'm looking for.
Here is a sample of my data.
My goal is to make a visual that shows the sum of the [BytesReceived] and [BytesSent] by date and to also not have it separated by [Location]. I assume the best way to do this is to create a new table that sums each column by date and leaves out the [Location], like this.
I'm not sure how to get from the sample data to the new table using a formula or if that is even the best way to go about doing this. These examples were made in Excel for illustrative purposes, but I would need to be able to do this in Power BI. Any suggestions on how I can/should do this?
Just create a Table visualization with only those 3 columns in it and not location.
3 Replies
Just create a Table visualization with only those 3 columns in it and not location.
Thank you! This worked perfectly.
Hi Gnaglor,
Have you tried the solution provided by Greg_Deckler above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards
