Forum Discussion

ShaneElford's avatar
ShaneElford
Regular Visitor
6 years ago
Solved

Merge multiple entries from data source into 1

Hi,

 

I'm new to PowerBI so am hoping this is a fairly simple one.  I have data reading from a CSV.  The data is gathering how long we have spent working for a client by individual time entries from our employees.  one client might have 20 hours total from 21 different time entries so it currently looks like this:

 

Is it possible to group this data by Client, date, and total hours (monthly)?

 

Preferably in query editor so we can import other data and work out how much a client needs to be charged.

 

Thanks!