Forum Discussion
Combine and sum values from multiple rows into one row
This is your data when you import them in Power BI.
Then you go on report, in the visualisation you chose table.
Then you drag and drop all your column that you need in "Values". And by left clicking in the Hours 1 in values you have all the options in my previous post and you chose "Sum". You do it for all the Hours column and you'll obtain the result I showed.
Thank you! How do you combine the rows into one row? Sorry I am really really new to this.
The top table is what I have. I need what I have to look like the bottom table with the values summed.
This is your data when you import them in Power BI.
Then you go on report, in the visualisation you chose table.
Then you drag and drop all your column that you need in "Values". And by left clicking in the Hours 1 in values you have all the options in my previous post and you chose "Sum". You do it for all the Hours column and you'll obtain the result I showed.
Thank you Frequent Visitor! I was making it too difficult.