Forum Discussion
Combine and sum values from multiple rows into one row
Please help me combine multiple rows into one and add the hours as shown here.
I am a new to Power BI and will greatly appreciate your help.
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.
4 Replies
hi Anonymous,
Make sur that when you add the Hours in your column you click on it in Values to select Sum.
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.