Forum Discussion
ShaneElford
6 years agoRegular Visitor
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!
1 Reply
- mussaendaCommunity Champion