Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
Our payroll application can export the working time per day of all employees in this format:
Date | Start time | End time |
John Smith | ||
01/01/2023 | 8:00 | 17:03 |
01/02/2023 | 8:02 | 17:10 |
01/03/2023 | 7:59 | 16:45 |
01/04/2023 | 8:10 | 17:00 |
01/05/2023 | 7:55 | 17:05 |
Jane Doe | ||
01/01/2023 | 8:03 | 16:55 |
01/02/2023 | 8:01 | 17:03 |
01/03/2023 | 7:55 | 17:10 |
01/04/2023 | 7:55 | 16:57 |
01/05/2023 | 8:00 | 18:30 |
I need to do a report calculating the total worked time per employee per month, but to do this I need to add a new column with the employee name in all the rows. How can I get the employee name that is now in the same column than the dates and put it into a new column?
Thank you very much in advance
Solved! Go to Solution.
Hi
let
Source = Your_Source,
Name = Table.AddColumn(Source, "Name", each if [Start time] = null then [Date] else null),
FillDown = Table.FillDown(Name,{"Name"}),
Filter = Table.SelectRows(FillDown, each [Start time] <> null)
in
Filter
Stéphane
Another solution
= Table.Group(
Source,
{"Date"},
{{"Data", each Table.Skip(_)}},
GroupKind.Local,
(x,y) => Number.From(y[Date] is text)
)
group, if row[date] is type text then new group, else same group
then expand
Stéphane
Hi
let
Source = Your_Source,
Name = Table.AddColumn(Source, "Name", each if [Start time] = null then [Date] else null),
FillDown = Table.FillDown(Name,{"Name"}),
Filter = Table.SelectRows(FillDown, each [Start time] <> null)
in
Filter
Stéphane
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |